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

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

A) data three;
set one;
if 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;
where char1 in ('new york' 'los angeles');
run;

2. The following SAS program is submitted:
%macro test(var);
proc print data = sasuser.class;
where age > &var;
run;
%mend;
Which type of parameter is the macro variable VAR?

A) command
B) keyword
C) positional
D) default

3. The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X.
Which one of the following SAS programs uses the index to select observations from the data set ONE?

A) data two;
set three;
set one (key = X);
run;
B) data two;
set three;
set one key = X;
run;
C) data two;
set one;
set three key = X;
run;
D) data two;
set three key = X;
set one;
run;

4. The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES:
SASUSERS.HOUSES OBS STYLE
1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT
The following SAS program is submitted:
proc sql noprint; select distinct style into :styles separated by ' ' from sasuser.houses order by style;
quit;
Which one of the following is the value of the resulting macro variable?

A) CONDO RANCH SPLIT TWOSTORY
B) RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT
C) RANCH SPLIT CONDO TWOSTORY
D) CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY

5. The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

A) any real number between 1 and 2,500,000
B) any real number between 0 and 1
C) any integer between 1 and 10
D) any integer between 1 and 2,500,000

質問と回答：