SASInstitute A00-212 問題集

質問 1：
The following SAS program is submitted:
options yearcutoff = 1950;
% macro y2kopt(date);
% if &date >= 14610 %then %do;
options yearcutoff = 2000;
% end;
% else %do;
options yearcutoff = 1900;
% end;
% mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
% y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for
YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?
A. 2000
B. 1950
C. 1900
D. 1920
正解：A

質問 2：
The following SAS program is submitted:
% macro test(var);
% let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
% let type = %index(&jobs,&var);
% mend;
% test(SMITH)
Which one of the following is the resulting value of the macro variable TYPE?
A. 0
B. 3
C. null
D. 6
正解：D

質問 3：
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?
A. DATASETS
B. FORMAT
C. CONTENTS
D. MODIFY
正解：A

質問 4：
Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes
that text to the log?
A. SOURCE2
B. MLOGIC
C. MPRINT
D. MSOURCE
正解：C

質問 5：
Given the following SAS data sets ONE and TWO:
ONE TWO
OBS COMMON X OBS COMMON Y
1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14
The following SAS DATA step is submitted:
data combine;
merge one two;
by common;
run;
Which one of the following represents the data values stored in data set COMBINE?
A. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 A 14 3
4 B 9 4
5 B 9 2
6 C 8 5
7 C 14 5
B. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 B 9 4
4 C 8 5
C. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 B 14 4
4 B 9 2
5 C 8 5
D. OBS COMMON X Y
1 A 10 1
2 A 13 1
3 A 14 1
4 A 10 3
5 A 13 3
6 A 14 3
7 B 9 4
8 B 9 2
9 C 8 5
10 C 14 5
正解：A

質問 6：
The following SAS program is submitted:
% let lib = %upcase(sasuser);
proc sql;
select nvar
from dictionary.tables
where libname = "&lib";
quit;
Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?
A. a syntax error in the log
B. a report showing the number of columns in each table in SASUSER
C. a report showing the names of each table in SASUSER
D. no result set
正解：B

質問 7：
Given the SAS data set WORK TRANSACT:

The following output is desired:

Which SQL statement was used?

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

質問 8：
Given has SAS dataset ONE:

The following SAS program is submitted:

Proc sql;
<insert SQL clause here>
from one;
quit;
The following output is desired:
Which SQL procedure clause completes the program and generates the desired output?
A. Select salary, salary*.10 name='BONUS'
B. Select salary, salary *.10 column='BONUS'
C. Select salary, salary*.10 label='BONUS'
D. Select salary, salary*.10 var=BONUS
正解：C