SASInstitute A00-231 問題集

質問 1：
The following SAS program is submitted:
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?
A. 15
B. 200
C. 6
D. 1
正解：B

質問 2：
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS
NAME AGE
Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm. Students;
file 'file specification';
put name $15. @5 age 2.;
run;
What is written to the output raw data file?
A. ---- I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
B. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14
C. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
D. ----I----10---I----20---I---- 30 Alfred 14 Alice 13 Barbara 13 Carol 14
正解：A

質問 3：
Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input@1 salary 6.;
if_error_then description = 'Problems';
else description = 'No Problems';
run;
What is the result?
A. The value of the DESCRIPTION variable is No Probl.
B. The value of the DESCRIPTION variable is Problems.
C. The value of the DESCRIPTION variable can not be determined.
D. The value of the DESCRIPTION variable is No Problems.
正解：B

質問 4：
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 a semicolon at the end of the SET statement.
B. Delete the word THEN on the IF statement.
C. Place quotes around the value on the IF statement.
D. Add an END statement to conclude the IF statement
正解：A

質問 5：
The Excel workbook REGIONS.XLSX contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS pcfiles path='c:\regions.xlsx';
Which PROC PRINT step correctly displays the NORTH worksheet?
A. proc print data=MYXLS.NORTH$; run;
B. proc print data=MYXLS.'NORTH$'n; run;
C. proc print data=MYXLS.NORTH.XLS; run;
D. proc print data=MYXLS.'NORTH'e; run;
正解：B