Thursday, 29 January 2015

45 TOP SAS Programming Interview Questions and Answers pdf free download(Part1)

1. What areas of SAS are you most interested in?

2. Describe 5 ways to do a "table lookup" in SAS.
A) Match Merging, Direct Access, Format Tables, Arrays, PROC SQL

3. What versions of SAS have you used (on which platforms)?
A) SAS 9.1.3,9.0, 8.2 in Windows and UNIX, SAS 7 and 6.12

4. What are some good SAS programming practices for processing very large data sets?
A) Sampling method using OBS option or subsetting, commenting the Lines, Use Data Null

5. What  are some problems you might encounter in processing missing values? In Data steps? Arithmetic?  Comparisons? Functions? Classifying data?
A) The result of any operation with missing value will result in missing value. Most SAS statistical procedures exclude observations with any missing variable values from an analysis.

6. How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?

7. What  is the different between functions and PROCs that calculate the same simple descriptive statistics?
A) Proc can be used with wider scope and the results can be sent to a different dataset. Functions usually affect the existing datasets.

8. If you were told to create many records from one record, show how you would do this using array and with PROC TRANSPOSE?
A) Declare array for number of variables in the record and then used Do loop Proc Transpose with VAR statement

9. What  do the SAS log messages "numeric values have been converted to character" mean? What are the implications?
A) It implies that automatic conversion took place to make character functions possible.

10. Why is a STOP statement needed for the POINT= option on a SET statement?
A) Because POINT= reads only the specified observations, SAS cannot detect an end-of-file condition as it would if the file were being read sequentially.
More Questions :-
Part1  Part2  Part3  Part4  Part5

No comments:

Post a Comment