SASInstitute A00-212 問題集

質問 1：
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

質問 2：
Consider the following SAS log:
229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;
230 set sasuser.houses;
231 if style = 'RANCH' then output sasuser.ranch;
232 else if style = 'CONDO' then output sasuser.condo;
233 run;
NOTE: DATA STEP view saved on file SASUSER.RANCH.
NOTE: A stored DATA STEP view cannot run under a different operating system.
234
235 proc print data = sasuser.condo;
ERROR: File SASUSER.CONDO.DATA does not exist.
236 run;
NOTE: The SAS System stopped processing this step because of errors.
Which one of the following explains why the PRINT procedure fails?
A. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.
B. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.
C. SASUSER.CONDO is a stored DATA step program.
D. A SAS data file and SAS data view cannot be created in the same DATA step.
正解：B

質問 3：
The following SAS program is submitted:
% let first = yourname;
% let last = first;
% put &&&last;
Which one of the following is the result in the log of the %PUT statement?
A. &first
B. yourname
C. first
D. &yourname
正解：B

質問 4：
The following SAS program is submitted:
date view=sauser.ranch;
describe;
run;
What is the result?
A. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor
window
B. The program retrieves the SAS source code that creates the view and places it in the output window
C. The program creates a DATA step view called SASUSER.RANCH and places it in the
SAS log
D. the program retrieves the SAS source code that creates the view and places it in the
SAS log
正解：D

質問 5：
The following SAS program is submitted:
% macro check(num=4);
% let result=%eval(&nm gt 5);
% put result is &result;
% mend;
% check (num=10)
What is written to the SAS log?
A. result is 1
B. result is 0
C. result is true
D. result is 10 gt 5
正解：A

質問 6：
What is an advantage of using a hash object in a SAS DATA step?
A. The hash object persists after the DATA step has executed
B. The hash object does not require unique keys
C. The hash object automatically sorts the data
D. The hash object key values can be multiple numeric and character data values
正解：D

質問 7：
Given the SAS data sets:

The SAS program is submitted:

What output will be produced?
A. Name
----------
Lauren
Smith
Patel
Farmer
Chang
Hiller
B. Name
----------
Chang
Chang
Lauren
C. Name
----------
Lauren
Patel
Chang
Chang
D. Name
----------
Patel
Chang
正解：A

質問 8：
Given the SAS date sets CLASS1 and CLASS2
CLASS1 CLASS2
NAME COURSE NAME COURSE
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hiller MATH2
The following SAS program is submitted:
Proc sql;
Select name from CLASS1
<insert SQL set operator here>
select name from CLASS;
quit;
The following output is desired
NAME
Chang
Chang
Lauren
Which SQL set operator completes the program and generates the desired output?
A. UNION ALL
B. EXCEPT ALL
C. INTERSECT ALL
D. OUTER UNION ALL
正解：B