SAS Institute A00-212 - SAS Advanced Programming for SAS 9 Exam
Page: 3 / 37
Total 184 questions
Question #11 (Topic: Single Topic)
The following SAS program is submitted:
%let dept=prod;
%let prod=merchandise;
The following message is written to the SAS log:
The value is "merchandise"
Which SAS System option writes this message to the SAS log?
%let dept=prod;
%let prod=merchandise;
The following message is written to the SAS log:
The value is "merchandise"
Which SAS System option writes this message to the SAS log?
A. %put the value is "&&&dept";
B. %put the value is "&&&dept";
C. %put the value is "&&&dept";
D. %put the value is %quote (&&&dept);
Answer: A
Question #12 (Topic: Single Topic)
The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and
LABEL and it consists of 10 observations.
The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?
LABEL and it consists of 10 observations.
The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?
A. It uses the WORK.TEMPDATA SAS data set as input to create the format
B. All formats created will be stored in two WORK.TEMPDATA SAS data set
C. An ERROR message is written to the SAS log because the program is incomplete
D. NO formats are created in this step
Answer: A
Question #13 (Topic: Single Topic)
The following SAS program is submitted:
date view=sauser.ranch;
describe;
run;
What is the result?
date view=sauser.ranch;
describe;
run;
What is the result?
A. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window
B. The program retrieves the SAS source code that creates the view and places it in the output window
C. The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log
D. the program retrieves the SAS source code that creates the view and places it in the SAS log
Answer: D
Question #14 (Topic: Single Topic)
Which SAS procedure changes the name of a permanent format for a variable stored in a
SAS data set?
SAS data set?
A. DATASETS
B. MODIFY
C. FORMAT
D. REGISTRY
Answer: A
Question #15 (Topic: Single Topic)
Given the SAS data set ONE:
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
%let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
%let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
A. 1234
B. sales
C. 5678
D. null
Answer: B
