A00-212 Exam Dumps - SAS Advanced Programming
The following SAS program is submitted:
data temp;
length 1 b 3 x;
infile 'file reference';
input a b x;
run;
What is the result?
Which one of the following options controls the pagesize of a SAS data set?
A data set stored on a network drive has the following characteristics:
- 14 Million observations
- 400 numeric variables
- 0 character variables of length 20
- Binary compression
A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this DATA Step?
The following SAS program is submitted:
Data sasuser.history;
Set sasuser.history(keep=state x y
Rename = (state=ST));
Total=sum(x, y);
Run;
The SAS data set SASUSER.HISTORY has an index on the variable STATE.
Which describes the result of submitting the SAS program?
The following SAS program is submitted:
%let value = 9;
%let value2 = 5;
%let newval = %eval(&value / &value2);
Which one of the following is the resulting value of the macro variable NEWVAL?
Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
M 28 200 20
M 25 100 10
M 28 300 10
M 33 300 30
F 18 100 50
F 25 200 10
F 35 400 50
The following SQL program is submitted:
proc sql;
create table two as
select distinct age
from one
where age < 33;
quit;
How many rows are written to the SAS data set TWO?
The SAS data set ONE contains the variables X,Y,Z and W.
The following SAS program is submitted:
Proc transpose data =one
Out=trans
Name=new;
By x;
var y;
run;
What are the names of all of the columns created by the TRANSPOSE procedure?
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?