Proper study guides for Regenerate SAS Institute SAS Advanced Programming Exam for SAS 9 certified begins with SAS Institute A00-212 preparation products which designed to deliver the Vivid A00-212 questions by making you pass the A00-212 test at your first time. Try the free A00-212 demo right now.
Q9. Which one of the following is the purpose of the REUSE= YES option in a compressed
SAS data set?
A. It temporarily compresses observations in a SAS data set.
B. It allows users to update the same SAS data set concurrently.
C. It allows new observations to be inserted wherever enough free space exists.
D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.
Answer: C
Q10. The following SAS program is submitted:
data new(bufsize = 6144 bufno = 4);
set old;
run;
What is the difference between the usage of BUFFSIZE= and BUFNO= options?
A. BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffers
B. BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers
C. BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers
D. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers
Answer: D
Q11. The following SAS program is submitted:
date view=sauser.ranch;
describe;
run;
What is the result?
A. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window
B. The program retrieves the SAS source code that creates the view and places it in the output window
C. The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log
D. the program retrieves the SAS source code that creates the view and places it in the SAS log
Answer: D
Q12. The following SAS program is submitted:
data new (bufsize = 6144 bufno = 4);
set old;
run;
Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?
A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.
B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.
C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.
D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.
Answer: B
Q13. Given the following SAS data set SASUSER.HIGHWAY:
SASUSER.HIGHWAY
STEERING SEATBELT SPEED STATUS COUNT
absent no 0-29 serious 31
absent no 0-29 not 1419
absent no 30-49 serious 191
absent no 30-49 not 2004
absent no 50+ serious 216
The following SAS program is submitted:
%macro highway;
proc sql noprint;
select count(distinct status)
into :numgrp
from sasuser.highway;
%let numgrp = &numgrp;
select distinct status
into :group1-:group&numgrp
from sasuser.highway;
quit;
%do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i" ;
run;
%end;
%mend;
%highway
How many reports are produced by the above program?
A. 0
B. 1
C. 2
D. 5
Answer: C
Q14. The following SAS program is submitted:
data new;
do i=1,2,3
nextfile=compress('March' || |);
infile abc filevar=nextfile
end=eof;
do until (eof);
input dept $sales;
end;
run;
What is the purpose of the FILEVAR=option on the INFILE statement?
A. It names the variable NEXTFILE, whose value is output to the SAS data set NEW
B. It names the variable NEXTFILE, whose values point to an aggregate storage location
C. It names the variable NEXTFILE, whose value is a SAS file reference
D. It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file
Answer: D
Q15. The following SAS program is submitted:
proc sort data = sales tagsort;
by month year;
run;
Which of the following resource(s) is the TAGSORT option reducing?
A. I/O usage only
B. CPU usage only
C. I/O and CPU usage
D. temporary disk usage
Answer: D
Q16. Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?
A. MODIFY and CHANGE statements
B. RENAME statement only
C. CHANGE statement only
D. MODIFY and RENAME statements
Answer: C