SASInstitute SAS advanced programming 認定 A00-202 試験問題:

1. Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS from one; quit;
Which one of the following represents the data values stored in the data set TWO?

A) CATEGORY SALARY BONUS EARNINGS
M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
B) CATEGORY SALARY BONUS EARNINGS
M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
C) CATEGORY EARNINGS
M 200 M 110 F 150 F 210
D) CATEGORY EARNINGS
M . M 110 F 150 F 210

2. The following SAS program is submitted:
data temp;
array points{2,3}_temporary_;
run;
Which one of the following is the maximum number of elements that are stored?

A) 6
B) 5
C) 2
D) 3

3. Given the following SAS data set ONE:
ONE REP COST
SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 JONES 200 JONES 400 SMITH 800 JONES 100 JONES 300
The following SAS program is submitted:
proc sql; select rep, avg(cost) as AVERAGE from one group by rep having avg(cost) > (select avg(cost) from one);
quit;
Which one of the following reports is generated?

A) REP AVERAGE
JONES 200
B) REP AVERAGE
SMITH 320
C) REP AVERAGE
JONES 320
D) REP AVERAGE
SMITH 500

4. Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

A) &RC
B) &ERR
C) &SYSERR
D) &SYSRC

5. The following SAS program is submitted:
<insert statement here>; %let development = ontime; proc print data = sasuser.highway;
title "For &dept"; title2 "This project was completed &development"; run;
Which one of the following statements completes the above and resolves title1 to "For research&development"?

A) %let dept = %str(research%&development);
B) %let dept = %str(research&development);
C) %let dept = %nrstr(research%&development);
D) %let dept = %nrstr(research&development);

質問と回答：