Online Access Free A00-212 Practice Test

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 output buffer in bytes; BUFNO= specifies the number of output buffers
• C.BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers
• D.BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers

Given a SAS data set with the following characteristics:
200 million observations
300 variables
Compressed
Resides on a network location
A SAS DATA Step program is written that will retrieve 20% of the data using a search based on a range of a character
variable.
Which type of statement is the best choice to minimize computer resource utilization when subsetting this data?

• A.IF/THEN/ELSE
• B.KEEP/DROP
• C.WHERE
• D.CASE

This question will ask you to provide a segment of missing code.
Given the SAS data set SASUSER.ORDERS:

The following SAS program is submitted:

Which statement completes the program completely so that it will produce a report with the total number of orders
for California?

• A.Num = California
• B.Syntax ('num', California)
• C.Call syntax ('num' California)
• D.&num = California

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 last
• C.What displays is two
• D.What displays is one

Given has SAS dataset ONE:

The following SAS program is submitted:

Proc sql;
<insert SQL clause here>
from one;
quit;
The following output is desired:
Which SQL procedure clause completes the program and generates the desired output?

• A.Select salary, salary*.10 var=BONUS
• B.Select salary, salary *.10 column='BONUS'
• C.Select salary, salary*.10 name='BONUS'
• D.Select salary, salary*.10 label='BONUS'