Act now and download your SAS Institute A00-212 test today! Do not waste time for the worthless SAS Institute A00-212 tutorials. Download Up to the immediate present SAS Institute SAS Advanced Programming Exam for SAS 9 exam with real questions and answers and begin to learn SAS Institute A00-212 with a classic professional.
Q41. The following SAS ARRAY statement is submitted:
array score{*} a4 - a10, a25 ;
Which one of the following is the maximum number of elements stored?
A. 3
B. 7
C. 8
D. 11
Answer: C
Q42. The following SAS program is submitted:
%let test=one;
%let one=two;
%let two=three;
%let three=last;
%put what displays is &&&&&test;
What is the written to the SAS log?
A. What displays is three
B. What displays is two
C. What displays is one
D. What displays is last
Answer: B
Q43. 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. data new;
set temp;
if a = 8 then
b = 'Small '
else if a in(1, 2) then
b = 'Medium'
else if a = 6 then
b = 'Large'
run;
B. data new;
set temp;
if a in (1, 2) then
b = 'Medium'
else if a = 8 then
b = 'Small'
else if a = 6 then
b = 'Large'
run;
C. data new;
set temp;
if a = 6 then
b = 'Large '
else if a in (1, 2) then
b = 'Medium'
else if a = 8 then
b = 'Small'
D. data new;
set temp;
if a = 6 then
b = 'Large '
if a in (1, 2) then
b = 'Small'
run;
Answer: C
Q44. Given the following SAS data set named WORK.INTERNAT:
WORK.INTERNAT
LOCATION SUM
USA 30
EUR 40
The following SAS program is submitted:
%let LOC = Usa; proc sql;
select *
from internat
where location = "&Loc";
quit;
Which one of the following is the result when the above code is executed on the above data set?
A. A report is generated with one destination.
B. No report is generated as the case of the compared values is different.
C. No report is generated as the case of the macro variable name is different.
D. A report is generated with the two original observations as the where clause does not work.
Answer: B
Q45. Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?
A. MPRINT
B. MLOGIC
C. MSOURCE
D. SOURCE2
Answer: A
Q46. Consider the following SAS log:
229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;
230 set sasuser.houses;
231 if style = 'RANCH' then output sasuser.ranch;
232 else if style = 'CONDO' then output sasuser.condo;
233 run;
NOTE: DATA STEP view saved on file SASUSER.RANCH.
NOTE: A stored DATA STEP view cannot run under a different operating system.
235 proc print data = sasuser.condo;
ERROR: File SASUSER.CONDO.DATA does not exist.
236 run;
NOTE: The SAS System stopped processing this step because of errors.
Which one of the following explains why the PRINT procedure fails?
A. SASUSER.CONDO is a stored DATA step program.
B. A SAS data file and SAS data view cannot be created in the same DATA step.
C. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.
D. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.
Answer: D
Q47. Which one of the following is the purpose of the IDXNAME= data set option?
A. It instructs SAS to name and store a specific index.
B. It instructs SAS to store an index in a particular location.
C. It instructs SAS to use a specific index for WHERE processing.
D. It instructs SAS to use any available index for WHERE processing.
Answer: C
Q48. The following SAS program is submitted:
%micro cols1;
name age;
%mend;
%macro cols2;
height weight
%mend
proc print data=sashelp.class;
<insert VAR statement here>
Run
Which VAR statement successfully completes the program and produces a report?
A. var heigh %cols1;
B. var %cols1 %cols2 height;
C. var %cols1 height;
D. var %cols2 %cols1;
Answer: A