![clinical sas interview questions and answers 2012 clinical sas interview questions and answers 2012](https://static.javatpoint.com/interview/images/sas-interview-questions-q2.png)
![clinical sas interview questions and answers 2012 clinical sas interview questions and answers 2012](https://www.coursehero.com/thumb/5c/50/5c500f782d92cdc9068cc8637fe76a688eef6b7a_180.jpg)
Therefore table can have only one clustered index. What Are The Difference Between Clustered And A Non-clustered Index?Ī clustered index is a special type of index that reorders the way records in the table are physically stored. It can be changed from the Network Utility TCP/IP properties. Which Tcp/ip Port Does Sql Server Run On? How Can It Be Changed? What is the purpose of the trailing and the How would you use them?ĪNS: holds the value past the data holds the value till a input statement or end of the line.ĭouble trailing When you have multiple observations per line of raw data, we should use double trailing signs at the end of the INPUT statement.Question 1. How many observations would be there at the end of data step execution?ġ6. Put function – Numeric to character conversion- put (source, format)ġ5. Which SAS statement does not perform automatic conversions in comparisons?ĪNS: Input function – Character to numeric conversion- Input (source, informat) What is the difference between SAS function and procedures?ĪNS: Functions expects argument value to be supplied across an observation in a SAS data set and procedure expects one variable value per observation.ġ3. What is the difference between reading the data from external file and reading the data from existing data set?ĪNS: The main difference is that while reading an existing data set with the SET statement, SAS retains the values of the variables from one observation to the next.ġ2. How would you delete duplicate observations?ġ1.
#Clinical sas interview questions and answers 2012 code#
How would you code the criteria to restrict the output to be produced?ġ0. How do you read in the variables that you need?ĪNS: Using Input statement with the column pointersĩ. What is the difference between an informat and a format?ĪNS: Informats read the data.
![clinical sas interview questions and answers 2012 clinical sas interview questions and answers 2012](https://data-flair.training/blogs/wp-content/uploads/sites/2/2018/04/SAS-interview-Questions-3-01-1-1200x900.jpg)
What is the function of Stop statement?ĪNS: Stop statement causes SAS to stop processing the current data step immediately and resume processing statement after the end of current data step.ħ. What SAS statements would you code to read an external raw data file to a DATA step?Ħ. What is the function of tranwrd function?ĪNS: TRANWRD function replaces or removes all occurrences of a pattern of characters within a character string.ĥ. Placing an explicit OUTPUT statement in a DATA step overrides the automatic output, so that observations are added to a data set only when the explicit OUTPUT statement is executed.Ĥ. What is the function of output statement?ĪNS: To override the default way in which the DATA step writes observations to output, you can use an OUTPUT statement in the DATA step. ANS: Scan, Substr, trim, Catx, Index, tranwrd, find, Sum.ģ.