SAS INSTITUTE -SAS Advanced Programming

Given the SAS date sets CLASS1 and CLASS2
CLASS1 CLASS2
NAME COURSE NAME COURSE
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hiller MATH2
The following SAS program is submitted:
Proc sql;
Select name from CLASS1

select name from CLASS;
quit;
The following output is desired
NAME
Chang
Chang
Lauren
Which SQL set operator completes the program and generates the desired output?

The following SAS program is submitted:
data new (bufnp=4);
set old(bufno=4);
run;
Why are the BUFNO options used?

The following SAS program is submitted:
options reuse=YES;
data sasuser RealEstate(compress=CHAR);
set sasuser houses;
run;

What is the effect of the REUSE=YES SAS system option?

The SAS data set ONE contains fifty million observations and contains the variable
PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

The following SAS program is submitted:
data temp;
set sasuser.history(kep=date);
format date qtr
if first.date then total=0;
total+1;
if last.date;
run;
proc print data=temp;
run
SASUSER.HISTORY is sorted by the SAS date variable DATE.
The following output is required:
Date Total
1 13
3 15
4 25
Which By statement completes the data step and successfully generates the required output?

Given the data set SASHELP.CLASS:
SASHELP.CLASS
NAME AGE
Mary 15
Philip 16
Robert 12
Ronald 15
The following SAS program is submitted:
%let value = Philip;
proc print data = sashelp.class;
run;
Which WHERE statement successfully completes the program and procedures a report?

Given the SAS dataset ONE
ONE
SALARY
200
205
523
The following SAS program is submitted
Proc sql;
Select * from one
;
quit;
The following output is desired:
SALARY
200
205
523
Which WHERE expression completes the program and generates the desired output?

At the start of a new SAS session; the following program is submitted:
%macro one;
data _null_;
call symput('proc','measn);
run;
proc &proc data=sashelp.class;
run;
%mend;
%one()
What is the result?

The following SAS program is submitted:
%let value=9;
%let add=5;
%let newval=%eval(&value/&add);
What is the value of the macro variable NEWVAL?

Given the non-indexed SAS data set TEMP:
TEMP
X Y
P 52
P 45
A 13
A 56
R 34
R 12
R 78
The following SAS program is submitted:
Proc print data=temp;
Run;
Which by statement completes the program, create a listing report that is grouped by X and completes without errors?