최신 SAS Institute Systems Certification A00-201 무료샘플문제:

1. Which one of the following is true when SAS encounters a data error in a DATA step?

A) A note appears in the SAS log that the incorrect data record was saved to a separate
SAS file for further examination.
B) The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
C) The DATA step stops executing at the point of the error, and no SAS data set is created.
D) A note is written to the SAS log explaining the error, and the DATA step continues to execute.

2. The following SAS program is submitted:
data numrecords;
infile 'file-specification';
input @1 patient $15.
relative $ 16-26 @;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15.
clinic $ 44-53
@ 54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step during execution?

A) 1
B) 4
C) 3
D) 2

3. The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet; run;
Which one of the following is needed to display the standard deviation with only two decimal places?

A) Add the statement FORMAT STD 7.2; in the MEANS procedure step.
B) Add the option FORMAT = 7.2 option to the MEANS procedure statement.
C) Add the option MAXDEC = 2 to the MEANS procedure statement.
D) Add the statement MAXDEC = 7.2; in the MEANS procedure step.

4. A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than
$100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

A) proc print data = sasuser.houses;
where price lt 60000;
where price gt 100000;
run;
B) proc print data = sasuser.houses;
where price lt 60000 or where price gt 100000;
run;
C) proc print data = sasuser.houses;
where price lt 60000 and price gt 100000;
run;
D) proc print data = sasuser.houses;
where price lt 60000 or price gt 100000;
run;

5. CORRECT TEXT
The following SAS program is submitted:
data work.new;
length word $7;
amount = 4;
if amount = 4 then word = 'FOUR';
else if amount = 7 then word = 'SEVEN';
else word = 'NONE!!!';
amount = 7;
run;
Which one of the following represents the values of the AMOUNT and WORD variables?

질문과 대답: