SASInstitute A00-201 問題集

質問 1：
The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?
A. 9
B. . (missing numeric value)
C. 6
D. The program fails to execute due to errors.
正解：A

質問 2：
Click the Exhibit button to view the output of a FREQ procedure.
The variable STYLE has a permanent label of "Style of homes" and the variable
BEDROOMS has a permanent label of "Number of bedrooms".
Which one of the following SAS programs produced the output shown in the exhibit?

A. proc freq data = sasuser.houses;
tables style;
tables bedrooms;
run;
B. proc freq data = sasuser.houses;
tables style and bedrooms;
run;
C. proc freq data = sasuser.houses;
tables style , bedrooms;
run;
D. proc freq data = sasuser.houses;
tables style * bedrooms;
run;
正解：A

質問 3：
The following SAS program is submitted:
data work.flights;
destination = 'CPH';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise;
end;
run;
Which one of the following is the value of the CITY variable?
A. Copenh
B. ' ' (missing character value)
C. Copenhagen
D. London
正解：A

質問 4：
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
< insert IF statement here>
run;
Which one of the following IF statements writes the last observation to the output data set?
A. if eof = 1;
B. if end = 0;
C. if end = 1;
D. if eof = 0;
正解：A

質問 5：
The SAS data set EMPLOYEE_INFO is listed below:

The following SAS program is submitted:
proc sort data = employee_info;
< insert BY statement here>
run;
Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?
A. by Expenses IDNumber;
B. by ascending (IDNumber Expenses);
C. by IDNumber Expenses;
D. by ascending IDNumber ascending Expenses;
正解：C

質問 6：
A SAS program is submitted and the following SAS log is produced:
2 data gt100;
3 set ia.airplanes
4 if mpg gt 100 then output;
22 202
ERROR: File WORK.IF.DATA does not exist.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;,
END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
5 run;
The IA libref was previously assigned in this SAS session.
Which one of the following corrects the errors in the LOG?
A. Add an END statement to conclude the IF statement.
B. Add a semicolon at the end of the SET statement.
C. Delete the word THEN on the IF statement.
D. Place quotes around the value on the IF statement.
正解：B

質問 7：
A raw data record is shown below:
07Jan2002
Which one of the following informats would read this value and store it as a SAS date value?
A. ddmmmyyyy9.
B. ddMMMyy9.
C. date9.
D. ddmonyy9.
正解：C

質問 8：
A raw data file is listed below:
----|----10---|----20---|----30
1 901 2
1 905 1
1 910 6
1 925 .
1 941 1
The following SAS program is submitted and references the raw data file above:
data coins;
infile 'file-specification';
input year quantity;
< insert statement(s) here>
run;
Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?
A. totquantity + quantity;
B. totquantity = sum(totquantity + quantity);
C. retain totquantity 0;
totquantity = totquantity + quantity;
D. totquantity 0;
sum totquantity;
正解：A

質問 9：
The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
Which one of the following is the value of the CITY variable?
A. Copenh
B. ' ' (missing character value)
C. Copenhagen
D. Other
正解：D