SASInstitute SAS Advanced Programming Exam for SAS 9 - A00-212 Exam Practice Test
The question will ask you to provide a segment of missing code.
The following SAS program is submitted:
The text box above, complete the %PUT statement to produce the following log output:
Case is ignored and standard SAS syntax rules apply.
The following SAS program is submitted:
The text box above, complete the %PUT statement to produce the following log output:
Case is ignored and standard SAS syntax rules apply.
Correct Answer:
_sample_
The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
Correct Answer: D
Vote an answer
Given the following SAS data sets ONE and TWO:
ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
Which one of the following reports is generated?
ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
Which one of the following reports is generated?
Correct Answer: B
Vote an answer
The following SAS program is submitted:
options yearcutoff = 1950;
% macro y2kopt(date);
% if &date >= 14610 %then %do;
options yearcutoff = 2000;
% end;
% else %do;
options yearcutoff = 1900;
% end;
% mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
% y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for
YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?
options yearcutoff = 1950;
% macro y2kopt(date);
% if &date >= 14610 %then %do;
options yearcutoff = 2000;
% end;
% else %do;
options yearcutoff = 1900;
% end;
% mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
% y2kopt(&date)
The SAS date for January 1, 2000 is 14610 and the SAS system option for
YEARCUTOFF is set to 1920 prior to submitting the above program.
Which one of the following is the value of YEARCUTOFF when the macro finishes execution?
Correct Answer: D
Vote an answer
This question will ask you to provide missing option.
Which option is required to complete the program correctly?
Which option is required to complete the program correctly?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
The purpose of FILEVAR = option on the INFILE statement is to name the variable next, whose value:
The purpose of FILEVAR = option on the INFILE statement is to name the variable next, whose value:
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Given the SAS data sets shown on the left, the SAS program on the right is submitted.
What will be the result when this program is executed?
What will be the result when this program is executed?
Correct Answer: D
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
The question will ask you to provide a segment of missing code.
Given the following SAS program:
Which segment of code completes the program to use finance.new SAS view?
Given the following SAS program:
Which segment of code completes the program to use finance.new SAS view?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
% let first=yourname;
% let last=first;
% put &&&last;
What is written to the SAS Log?
% let first=yourname;
% let last=first;
% put &&&last;
What is written to the SAS Log?
Correct Answer: B
Vote an answer
The following SAS program is submitted:
% macro location;
data _null_;
call symput ('dept','sales');
run;
% let country=Germany;
% put_global_;
% mend;
% let company = ABC;
% location;
Which macro variables are written to the SAS log?
% macro location;
data _null_;
call symput ('dept','sales');
run;
% let country=Germany;
% put_global_;
% mend;
% let company = ABC;
% location;
Which macro variables are written to the SAS log?
Correct Answer: B
Vote an answer
Given the SAS data set WORK.ONE:
The following SAS program is submitted;
Which result set would be generated?
The following SAS program is submitted;
Which result set would be generated?
Correct Answer: C
Vote an answer
What is generated as a result of submitting the RANUNI function with a seed of 123?
Correct Answer: A
Vote an answer