1.
Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?
2.
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?
3.
Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?
4.
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?
5.
Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?
6.
Given the following SAS data set ONE:
ONE
LEVEL AGE
1 10
2 20
3 20
2 10
1 10
2 30
3 10
2 20
3 30
1 10
The following SAS program is submitted:
proc sql;
select level, max(age) as MAX
from one
group by level
having max(age) > (select avg(age) from one);
quit;
Which one of the following reports is generated?
7.
Which one of the following is true regarding the KEEP statement?
8.
Which one of the following displays the definition of a stored SQL procedure view in the SAS log?
9.
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?
10.
Which one of the following is the purpose of the IDXNAME= data set option?