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：
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

質問 3：
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----30Alfr14Alic13Barb13aCarol 4
B. ----I----10---I----20---I----30Alfred14Alice13Barbara13Carol14
C. ----I----10---I----20---I----30Alfred 14Alice 13Barbara 13Carol 14
D. ----I----10---I----20---I----30Alfr14edAlic130Barb13araCaro141
正解：A

質問 4：
Given the following raw data records in TEXTFILE.TXT:

The following output is desired:

Which SAS program correctly produces the desired output?

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

質問 5：
The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end;
run;
Which one of the following is the value of the variable CALLS in the output data set?
A. 4
B. 6
C. 7
D. 5
正解：C

質問 6：
The following SAS program is submitted:
data work.retail;
cost = '20000';
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?
A. '2000'
B. 2000
C. ' ' (missing character value)
D. . (missing numeric value)
正解：B

質問 7：
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
A. The _ERROR_ variable contains the number of the observation that caused the data error.
B. The _ERROR_ variable can be used in expressions in the DATA step.
C. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
D. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
正解：B

質問 8：
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :

Which expression successfully completed the program and creates the variable DAY?
A. day(BeginDate)
B. dayofweek(BeginDate)
C. getday(BeginDate,today())
D. weekday(BeginDate)
正解：D