Here are some common SAS questions:
1- What happens if no VAR statement is used in PROC PRINT?
2- Understand how SAS processes a data step
3- Explain what a (data step) SELECT statement does
4- What is the default length of a numeric variable?
5-What is the difference between DO WHILE and DO UNTIL?
6-What does BY after SET A; do?
7-What does BY after SET A B; do?
8-What is a sub-setting IF statement?
If you pass it doesn’t mean you’re good; but if you’re good, you should pass
9- What’s the difference between INFILE and INPUT?
10-What information is given by a Proc Contents?
11-How do you modify the header?
12-Which elements can you change? (in reference to question 10-11)
13-Which elements can you NOT change without re-creating the dataset?(in reference to question 10-11)
14-What is the purpose of the single trailing @ sign?
15-What statements are used to include or exclude specific variables in a data step?
16-How can you generate a 2-dimensional cross-tabulation?
17-In the macro language, all macro commands begin with?
18-What occurs if multiple datasets are included in a SET statement?
19-What symbol is used to concatenate two character values?
20-Explain the substr function
21-What are the differences among these functions? Round(), Ceil(), Floor()
22-What happens if you use the same in= variable for 2 datasets?
23-How do you begin a data step if you do not want to create a SAS dataset?
24-What are the automatic variables first. and last. ?
25-What does a 2 level input dataset name such as MydataSet.Mydata indicate ?
26-What is the default libname, where one-level dataset names go?
27-What statement allows you to keep track of previous values of variables or keep a running total?
28-What happens if you retain the value of a variable in the incoming dataset?
29-When an invalid data field is encountered when inputting a numeric variable, what happens?
30-What’s the difference between $w. and $CHARw. informats?
31-Explain the _type_ variable generated by proc summary
32-What is the purpose of a %GLOBAL statement?
33-What do CALL SYMPUT and CALL SYMGET do?
34-What date is the reference date for calculating the value of a SAS date variable?
35-What is _n_?
There are 10 kinds of people in the world: those who understand binary, and those who don’t.
Those are SAS most common questions you will be asked during a SAS programming job interview or if you plan in taking the SAS based certification.
In future blogs, I will try to cover each of those questions individually with some demonstrations.
Your comments and questions are valued and encouraged.
Anayansi Gamboa has an extensive background in clinical data management as well as experience with different EDC systems including Oracle InForm, InForm Architect, Central Designer, CIS, Clintrial, Medidata Rave, Central Coding, OpenClinica, Open Source and Oracle Clinical.