A00-212問題集、SASInstitute実際の試験問題

質問 1

Given the non-indexed SAS data set TEMP:
TEMP
X Y
--
P 52
P 45
A 13
A 56
R 34
R 12
R 78
The following SAS program is submitted:
Proc print data=temp;
<insert BY statement here>
run;
Which BY statement completes the program, creates a listing report that is grouped by X and completes without
errors?

A. By X;

B. By X grouped;

C. By X notsorted;

D. By Descending X;

正解: C

質問 2

The following SAS program is submitted:
% let a=cat;
% macro animal(a=frog);
% let a=bird;
% mend;
% animal(a=pig)
% put a is &a;
What is written to the SAS log?

A. a is bird

B. a is frog

C. a is pig

D. a set cat

正解: D

質問 3

Which title statement would always display current date?

A. title "Today is: &sysdate.";

B. title " Today is: & today.";

C. title "Today is: sysfunc (today (), worddate)";

D. title "Today is: & sysdate. ";

正解: A

質問 4

In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

A. data three;
set one;
where char1 in ('new york' 'los angeles');
run;

B. proc sql;
create table three as
select *
from one, two
where one.char1 > two.char1;
quit;

C. data three;
set one;
set two key = char1;
run;

D. data three;
set one;
if char1 in ('new york' 'los angeles');
run;

正解: C

質問 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 is not

B. Where salary ne missing

C. Where salary is not missing

D. Where salary ne null

正解: C

質問 6

Which one of the following programs contains a syntax error?

A. proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s
where p.item = c.item and
p.item = s.item;
quit;

B. proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;

C. proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s
where p.item = c.item and
p.item = s.item;
quit;

D. proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;

正解: B

質問 7

The following SAS program is submitted:

What is written to the SAS log?

A. WARNING: Apparent symbolic reference ROOT2 not resolved

B. MATH1

C. &Name2

D. MATH3

正解: D

質問 8

Given the following SAS program:

What will be the output from the PRINT Procedure?

A. Option A

B. Option C

C. Option B

D. Option D

正解: B

質問 9

Which one of the following is true regarding the KEEP statement?

A. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is
created.

B. The KEEP statement is available in both the DATA and the PROC steps.

C. The KEEP statement selects the variables read from the input data set(s).

D. The KEEP statement applies to all data sets created within the same DATA step.

正解: D

質問 10

The following SAS program is submitted:
% macro execute;
<insert statement here>
proc print data = sasuser.houses;
run;
% end;
% mend;
Which of the following completes the above program so that it executes on Tuesday?

A. %if &sysday = 'Tuesday' %then %do;

B. %if &sysday = Tuesday %then %do;

C. %if "&sysday" = Tuesday %then %do;

D. %if '&sysday' = 'Tuesday' %then %do;

正解: B

質問 11

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

A. DATASETS

B. CONTENTS

C. MODIFY

D. FORMAT

正解: A

質問 12

The following SAS program is submitted:
proc contents data = testdata.one;
run;
Which one of the following SQL statements produces similar information about the column attributes as the above
CONTENTS procedure?

A. proc sql;
show testdata.one;
quit;

B. proc sql;
show table testdata.one;
quit;

C. proc sql;
describe table testdata.one;
quit;

D. proc sql;
describe testdata.one;
quit;

正解: C

SASInstitute SAS Advanced Programming Exam for SAS 9 - A00-212 模擬練習