Most Asked SAS Interview Questions and Answers

SAS Interview Questions and Answers most commonly asked for Experienced PDF, Freshers candidates for Employment.

What are some good SAS programming practices for processing very large data sets?

Sort them once, can use firstobs = and obs = ,

What is the different between functions and PROCs that calculate thesame simple descriptive statistics?

Functions can used inside the data step and on the same data set but with proc’s you can create a new data sets to output the results. May be more ………..

If you were told to create many records from one record, show how you would do this using arrays and with PROC TRANSPOSE?

I would use TRANSPOSE if the variables are less use arrays if the var are more …………….. depends

What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data?

In unsorted data you can’t use First or Last.

How do you debug and test your SAS programs?

First thing is look into Log for errors or warning or NOTE in some cases or use the debugger in SAS data step.

What other SAS features do you use for error trapping and datavalidation?

Check the Log and for data validation things like Proc Freq, Proc means or some times proc print to look how the data looks like ……..

How would you combine 3 or more tables with different structures?

I think sort them with common variables and use merge statement. I am not sure what you mean different structures.

What are _numeric_ and _character_ and what do they do?

Will either read or writes all numeric and character variables in dataset.

For what purpose would you use the RETAIN statement?

The retain statement is used to hold the values of variables across iterations of the data step. Normally, all variables in the data step are set to missing at the start of each iteration of the data step. What is the order of evaluation of the comparison operators: + – * / ** ()?A) (), **, *, /, +, –

How could you generate test data with no input data?

Using Data Null and put statement

How do you debug and test your SAS programs?

Using Obs=0 and systems options to trace the program execution in log.

What can you learn from the SAS log when debugging?

It will display the execution of whole program and the logic. It will also display the error with line number so that you can and edit the program.

What is the purpose of error?

It has only to values, which are 1 for error and 0 for no error.

How do you test for missing values?

Using Subset functions like IF then Else, Where and Select.

In the flow of DATA step processing, what is the first action in a typical DATA Step?

When you submit a DATA step, SAS processes the DATA step and then creates a new SAS data set.( creation of input buffer and PDV)
Compilation Phase
Execution Phase


Popular posts from this blog

TOP Agile Testing Interview Questions and Answers

Latest Agile Testing Interview Questions and Answers

Most Asked ADO.NET Interview Questions and Answers