SAS INSTITUTE -SAS Advanced Programming Set 2

Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?

The following SAS program is submitted:
%let test=one;
%let one=two;
%let two=three;
%let three=last;
%put what displays is &&&&&test;
What is the written to the SAS log?

The following SAS program is submitted:
data temp:
array points { 2,3 } (10,15,20,25,30,35);
run;
What impact does the ARRAY statement have in the program Data vector (PDV)?

Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?

What is generated as a result of submitting the RANUNI function with a seed of 123?

What is an advantage of using a hash object in a SAS DATA step?

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

The following SAS program is submitted:
;
%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"?

Which one of the following options controls the pagesize of a SAS data set?

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?