Thursday, 31 January 2013

FAQ from SAS procedure

The most surprising question in SAS interview 

*Have you ever used "Proc Merge”? (be prepared for surprising answers….)
 
*If you were given several SAS datasets you were unfamiliar with, how would you find out the variable names and formats of each dataset?
*What SAS PROCs have you used and consider yourself proficient in using?
*How would you keep SAS from overlaying the a SAS set with its sorted version?
*In PROC PRINT, can you print only variables that begin with the letter "A"?
*What are some differences between PROC SUMMARY and PROC MEANS?

PROC FREQ:
* Code the tables statement for a single-level (most common) frequency.
* Code the tables statement to produce a multi-level frequency.
* Name the option to produce a frequency line items rather that a table.
* Produce output from a frequency. Restrict the printing of the table.


PROC MEANS:
* Code a PROC MEANS that shows both summed and meaned output of the data.
* Code the option that will allow MEANS to include missing numeric data to be included in the    report.
* Code the MEANS to produce output to be used later.
*Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

No comments:

Post a Comment