Free A00-212 Exam Braindumps
SAS Advanced Programming Exam for SAS 9 Questions 41–45 (page: 10)

Given the SAS dataset ONE ONE
ONE
SALARY
200
205
523
The following SAS program is submitted
Proc sql;
Select * from one
<Insert Where expression here>;
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;
<insert By statement here?
Run;

Which by statement completes the program, create a listing report that is grouped by X and completes without errors?

Which of the following is true about the COMPRESS=YES data set option?