SASInstitute A00-212 問題集

質問 1：
The following SAS program is submitted:

What is written to the SAS log?
A. MATH3
B. &Name2
C. MATH1
D. WARNING: Apparent symbolic reference ROOT2 not resolved
正解：A

質問 2：
Which one of the following SAS SORT procedure options eliminates identical consecutive observations?
A. DISTINCT
B. NODUPKEY
C. UNIQUE
D. NODUP
正解：D

質問 3：
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?
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);
正解：B

質問 4：
The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
A. data new;
set temp;
if a = 8 then
b = 'Small ';
else if a in(1, 2) then
b = 'Medium';
else if a = 6 then
b = 'Large';
run;
B. data new;
set temp;
if a = 6 then
b = 'Large ';
else if a in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small';
C. data new;
set temp;
if a in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small';
else if a = 6 then
b = 'Large';
run;
D. data new;
set temp;
if a = 6 then
b = 'Large ';
if a in (1, 2) then
b = 'Small';
run;
正解：B

質問 5：
This question will ask you to provide a segment of missing code.
Given the SAS data set SASUSER.ORDERS:

The following SAS program is submitted:

Which statement completes the program completely so that it will produce a report with the total number of orders
for California?
A. Num = California
B. Call syntax ('num' California)
C. &num = California
D. Syntax ('num', California)
正解：A

質問 6：
Which one of the following statements is true regarding a SAS DATA step view?
A. It contains a partially compiled DATA step.
B. It contains global statements.
C. It allows write capabilities.
D. It contains data and a descriptor portion.
正解：A

質問 7：
This question will ask you to provide a segment of missing code.
Given the SAS data set SASUSER.HIGHWAY:

The following SAS program is submitted:

Which SQL clause stores the text 0-29, 30-49, 60+ in the macro variable GROUPS?
A. : into GROUPS delimited by ' , '
B. into : GROUPS separated by ' , '
C. : into GROUPS separated = ' , '
D. Into : GROUPS delimited by ' , '
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
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?
A. null
B. sales
C. 1234
D. 5678
正解：B