SASInstitute A00-202 試験概要:

SASInstitute A00-202 試験シラバストピック:

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

問題 #1
The following SAS program is submitted:
data two;
y = '2'; run;
%let x = 10;
%let var = y;
data one;
set two (keep = &var);
z = &var * &x;
run;
Which one of the following is the value of the variable Z when the program finishes execution?

A. _ERROR_
B. . (missing numeric)
C. 20 (as a numeric)
D. 20 (as a character)

問題 #2
Given the following SAS data set ONE:
ONE CATEGORY AGE SALARY BONUS
M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10
F 35 400 50
The following SAS program is submitted:
proc sql;
select distinct category,
sum(sum(salary,bonus)) as EARNINGS
from one
where age < 30
group by category
having calculated EARNINGS < 500;
quit;
Which one of the following reports will be generated?

A. CATEGORY EARNINGS
F 360
B. CATEGORY EARNINGS
M 640 F 360
C. CATEGORY EARNINGS M 220 M 110 M 310 F 150 F 210
D. CATEGORY EARNINGS
F 150 F 210

問題 #3
The following SAS program is submitted.
filename sales ('external-file1' 'external-file2');
data new;
infile sales;
input date date9. company $ revenue; run;
Which one of the following is the result of including the FILENAME statement in this program?

A. The FILENAME statement associates SALES with external-file2 followed by external-file1.
B. The FILENAME statement produces an ERROR message in the SAS log.
C. The FILENAME statement reads record 1 from external-file 1, reads record 1 from external-file 2, and combines them into one record.
D. The FILENAME statement associates SALES with external-file1 followed by external-file2.

問題 #4
The following SAS program is submitted:
%macro test(var); %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
%let type = %index(&jobs,&var);
%mend;
%test(SMITH)
Which one of the following is the resulting value of the macro variable TYPE?

A. 6
B. 0
C. null
D. 3

問題 #5
The following SAS program is submitted:
options yearcutoff = 1950;
%macro y2kopt(date);
%if &date >= 14610 %then %do;
options yearcutoff = 2000;
%end;
%else %do;
options yearcutoff = 1900;
%end; %mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
%y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

A. 2000
B. 1920
C. 1900
D. 1950

解説：