SASInstitute A00-211 問題集

質問 1：
The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?
A. The variable JCODE is written to the output data set.
B. The variable JOBCODE is written to the output data set.
C. Neither variable JCODE nor JOBCODE is written to the output data set.
D. The program fails to execute due to errors.
正解：B

質問 2：
Which step displays a listing of all the data sets in the WORK library?
A. proc contents lib=WORK.all;run;
B. proc contents data=WORK _ALL_;run;
C. proc contents data=WORK._all_;run;
D. proc contents lib=WORKrun;
正解：C

質問 3：
The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent
F11110.0020.0050.00
12220.0040.0040.00
13220.0040.0066.67
Total550.00100.00
M11110.0020.0050.00
12330.0060.0060,00
13110.0020.0033.33
Total550.00100.00
Total11220.00100.00
12550.00100.00
13330.00100.00
Total10100.00
Which option correctly completes the program and creates the report?
A. NOCROSSTAB
B. LIST
C. NOCOLS
D. CROSSLIST
正解：D

質問 4：
Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

The following SAS program is submitted:
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Which output is correct?
正解：
Pending

質問 5：
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
A. department=trim(dept)||put(number,3.);
B. department = dept II number;
C. department = trim(dept) number;
D. department = left(dept) II number;
正解：A

質問 6：
Given the raw data file YEARAMT:
----|---10---|---20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile 'yearamt';
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?
A. retain totquantity0; totquantity = totquantity + quantity;
B. totquantity + quantity;
C. totquantity = sum(totquantity + quantity);
D. retain totquantity; totquantity = totquantity + quantity;
正解：B

質問 7：
Which of the following programs correctly invokes the DATA Step Debugger?

A. Option A
B. Option C
C. Option D
D. Option B
正解：B

質問 8：
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:
Obs name level
1 Frank 1
2 Joan 2
3 Sui 2
4 Jose 3
5 Burt 4
6 Kelly .
7 Juan 1
The following SAS program is submitted:
data work.expertise;
set work.levels;
if level = . then
expertise = 'Unknown';
else if level = 1 then
expertise = 'Low';
else if level = 2 or 3 then
expertise = 'Medium';
else
expertise = 'High';
run;
Which of the following values does the variable EXPERTISE contain?
A. Low, Medium, High, and Unknown only
B. Low, Medium, and High only
C. Low, Medium, High, Unknown, and ' ' (missing character value)
D. Low, Medium, and Unknown only
正解：D