Q 1: Which SAS statement repetitively executes several statements while the value of Cholesterol is greater than 200?
A. do cholesterol gt 200;
B. do cholesterol > 200;
C. do while (cholesterol > 200);
D. do while cholesterol > 200;
Q 2: Which of the following statements is false about BY-group processing?
When you use the BY statement with the SET statement,
A. FIRST. and LAST. identify the first and last observation in each BY group, in that order.
B. the DATA step automatically creates two variables, FIRST. and LAST., for each variable in the BY statement.
C. the data sets that are listed in the SET statement must be indexed or sorted by the values of the BY variable(s).
D. FIRST. and LAST. are stored in the data set.
Q 3: A typical value for the character variable Target is 123,456. Which statement correctly converts the values of Target to numeric values when creating the variable TargetNo?
Q 4: The COMMAw.d informat can be used to read which of the following values?
A. all the three
D. 18 %
Q 5: Which statement will limit a PROC MEANS analysis to the variables Boarded, Transfer, and Deplane?
A. by boarded transfer deplane;
B. var boarded transfer deplane;
C. output boarded transfer deplane;
D. class boarded transfer deplane;
Q 6: When the code shown below is run, what will the file D:\Output\frame.html display?
ods html body='d:\output\body.html'
A. The file D:\Output\contents.html.
B. The file D:\Output\frame.html.
C. It displays no other files.
D. The files D:\Output\contents.html and D:\Output\body.html.
Q 7: Which SAS statement associates the fileref Crime with the raw data file C:\States\Data\Crime?
A. filename crime 'c:\states\data\crime';
B. fileref crime 'c:\states\data\crime';
C. filename crime c:\states\data\crime;
D. filename 'c:\states\data\crime' crime;
Q 8: What is wrong with this program?
input Item $ 1-13 IDnum $ 15-19 Instock 21-22
A. missing semicolon on third line
B. incorrect order of variables
C. missing semicolon on second line
D. incorrect variable type
Q 9: Which of the following programs contain a syntax error?
A. none of the above.
B. proc sort data=sasuser.mysales;
C. dat sasuser.mysales;
D. proc print data=sasuser.mysales label;
label region='Sales Region';
Q 10: What happens if you submit the following program?
proc sort data=clinic.diabetes;
proc print data=clinic.diabetes;
var age height weight pulse;
A. The PROC PRINT step runs successfully, printing observations in their sorted order.
B. The PROC SORT step generates errors and stops processing, but the PROC PRINT step runs successfully, printing observations in their original (unsorted) order.
C. The PROC SORT step runs successfully, but the PROC PRINT step generates errors and stops processing.
D. The PROC SORT step permanently sorts the input data set.