SASInstitute SAS Advanced Programming Exam for SAS 9 - A00-212 FREE EXAM DUMPS QUESTIONS & ANSWERS
The following SAS ARRAY statement is submitted:
array score{*} a4 - a10, a25 ;
Which one of the following is the maximum number of elements stored?
array score{*} a4 - a10, a25 ;
Which one of the following is the maximum number of elements stored?
Correct Answer: C
Vote an answer
Given the SAS data set ONE:
ONE
REP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted:
Proc sql;
Select rep, avg(cost) as AVERAGE
From one
Group by rep
<insert SQL procedure clause here>
quit;
The following output is desired:
Which SQL procedure clause completes the program and generates the desired output?
ONE
REP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted:
Proc sql;
Select rep, avg(cost) as AVERAGE
From one
Group by rep
<insert SQL procedure clause here>
quit;
The following output is desired:
Which SQL procedure clause completes the program and generates the desired output?
Correct Answer: C
Vote an answer
What is an advantage of using a hash object in a SAS DATA step?
Correct Answer: C
Vote an answer
Which one of the following automatic SAS macro variables contains the return code from a previously executed step?
Correct Answer: B
Vote an answer
Which one of the following is the purpose of the IDXNAME= data set option?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
options mprint;
% macro test(parm);
proc &parm data = sashelp.prdsale;
run;
% mend;
% test(print)
What is the result of the MPRINT options?
options mprint;
% macro test(parm);
proc &parm data = sashelp.prdsale;
run;
% mend;
% test(print)
What is the result of the MPRINT options?
Correct Answer: C
Vote an answer
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;
<insert WHERE statement here>
run;
Which WHERE statement successfully completes the program and procedures a report?
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;
<insert WHERE statement here>
run;
Which WHERE statement successfully completes the program and procedures a report?
Correct Answer: B
Vote an answer
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, creates a listing report that is grouped by X and completes without
errors?
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, creates a listing report that is grouped by X and completes without
errors?
Correct Answer: B
Vote an answer
Which one of the following options is available for SAS macro debugging?
Correct Answer: B
Vote an answer
The following SAS program is submitted:
% macro execute;
<insert statement here>
proc print data = sasuser.houses;
run;
% end;
% mend;
Which of the following completes the above program so that it executes on Tuesday?
% macro execute;
<insert statement here>
proc print data = sasuser.houses;
run;
% end;
% mend;
Which of the following completes the above program so that it executes on Tuesday?
Correct Answer: C
Vote an answer
Given the following SAS data set ONE:
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
data _null_;
set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
data _null_;
set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?
Correct Answer: A
Vote an answer
This question will ask you to provide a segment of missing code.
Given the SAS data set WORK EXAM:
TotalScore
----------------
512
657
*
782
The following SAS program is submitted:
The following output is desired:
TotalScore
--------------
512
657
782
Which WHERE expression completes the program and generates the desired output?
Given the SAS data set WORK EXAM:
TotalScore
----------------
512
657
*
782
The following SAS program is submitted:
The following output is desired:
TotalScore
--------------
512
657
782
Which WHERE expression completes the program and generates the desired output?
Correct Answer: D
Vote an answer
Given the SAS data sets:
The following SAS DATA step is submitted:
What data values are stored in data set WORK.COMBINE?
The following SAS DATA step is submitted:
What data values are stored in data set WORK.COMBINE?
Correct Answer: B
Vote an answer
Given the data sets shown on the left, the SAS program shown on the right is submitted.
What will be output by the program?
What will be output by the program?
Correct Answer: D
Vote an answer
Given the SAS data sets:
The SAS program is submitted:
What output will be produced?
The SAS program is submitted:
What output will be produced?
Correct Answer: A
Vote an answer