A00-212無料問題集「SASInstitute SAS Advanced Programming Exam for SAS 9」

質問 1

Which SAS procedure changes the name of a permanent format for a variable stored in a
SAS data set?

（A）FORMAT

（B）MODIFY

（C）DATASETS

（D）REGISTRY

質問 2

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 report showing the names of each table in SASUSER

（B）no result set

（C）a syntax error in the log

（D）a report showing the number of columns in each table in SASUSER

正解：D 解答を投票する

質問 3

Which one of the following statements is true regarding a SAS DATA step view?

（A）It contains data and a descriptor portion.

（B）It contains global statements.

（C）It contains a partially compiled DATA step.

（D）It allows write capabilities.

正解：C 解答を投票する

質問 4

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.

正解：

質問 5

Given the SAS dataset ONE
ONE
SALARY
200
205
523
The following SAS program is submitted
Proc sql;
Select * from one
<Insert Where expression here>;
quit;
The following output is desired:
SALARY
200
205
523
Which WHERE expression completes the program and generates the desired output?

（A）Where salary ne missing

（B）Where salary is not

（C）Where salary is not missing

（D）Where salary ne null

正解：C 解答を投票する

質問 6

Given the SAS data set WORK TRANSACT:

The following output is desired:

Which SQL statement was used?

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：A 解答を投票する

質問 7

The following SAS program is submitted:
% micro cols1;
name age;
% mend;
% macro cols2;
height weight
% mend
proc print data=sashelp.class;
<insert VAR statement here>
Run
Which VAR statement successfully completes the program and produces a report?

（A）var %cols1 height;

（B）var %cols1 %cols2 height;

（C）var heigh %cols1;

（D）var %cols2 %cols1;

正解：C 解答を投票する

質問 8

The SAS data set ONE contains the variables X, Y, Z, and W.
The following SAS program is submitted:
proc transpose data = one
out = trans
name = new;
by x;
var y;
run;
Which one of the following contains all the names of the columns created by the
TRANSPOSE procedure?

（A）new, X, and COL1

（B）new, X, Y, and _COL1_

（C）X, Y, Z, and W

（D）_NAME_, X, and Y

正解：A 解答を投票する

質問 9

Given the data set shown in the left, the SAS program on the right is submitted.