SASInstitute A00-212 問題集

質問 1：
The following SAS program is submitted:
% let value = .5;
% let add = 5;
% let newval = %eval(&value + &add);
Which one of the following is the resulting value of the macro variable NEWVAL?
A. .5 + 5
B. 5.5
C. null
D. 5
正解：C

質問 2：
Following SAS program is submitted:
data temp(<insert option here>);
infile 'rawdata';
input x $ y z;
run;
RAWDATA is a file reference to an external file that is ordered by the variable X.
Which option specifies how the data in the SAS data set TEMP will be sorted?
A. ORDEREDBY=X
B. SORTSYNC=X
C. SORTEDBY=X
D. GROUPBY=X
正解：C

質問 3：
Given the SAS data set SAUSER.HIGWAY:
SASUSER.HIGHWAY

The following SAS program is submitted:
% macro highway;
proc sql nonprint;
% let numgrp=6;
select distinct status into:group1-:group&numgrp from sasuser.highway;
quit;
% do i=1 %to &numgrp;
proc print data =sasuser.highway;
where status ="&&group&I";
run;
% end;
% mend;
% highway
How many reports are produced?
A. 0
B. 2
C. 6
D. 5
正解：B

質問 4：
Given the SAS data sets:

A SAS program is submitted and the following is written to SAS to:

What would allow the program to successfully execute without errors?
A. Replace the 104 with:
Where EMPLOYEE.Name = Any (Select names separated with ','
From WORK.NEWEMPLOYEE
Where Salary > 40000);
B. Qualify the column names with the table names.
C. Replace the equal sign with In operator.
D. Replace the where clause with:
Where EMPLOYEE.Name = (Select Names delimited with ','
From WORK.NEWEMPLOYEE
Where Salary > 40000);
正解：A

質問 5：
Given the following SAS data set named WORK.INTERNAT:
WORK.INTERNAT
LOCATION SUM
USA 30
EUR 40
The following SAS program is submitted:
% let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc";
quit;
Which one of the following is the result when the above code is executed on the above data set?
A. No report is generated as the case of the macro variable name is different.
B. A report is generated with one destination.
C. No report is generated as the case of the compared values is different.
D. A report is generated with the two original observations as the where clause does not work.
正解：C

質問 6：
Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?
A. DICTIONARY.MEMBERS
B. DICTIONARY.TABLES
C. DICTIONARY.VARIABLES
D. DICTIONARY.COLUMNS
正解：D

質問 7：
This item will ask you to provide a segment of missing code.
Given the input data set shown on the left and the output data set shown on the right:

In the text below, enter the code that will complete the program to produce the output set shown above on the right.

Case is ignored and standard SAS syntax rules apply.
正解：
N

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