Online Access Free A00-212 Practice Test

Given the data set shown in the left, the SAS program on the right is submitted.

Which program will result in the identical report?

• A.Option B
• B.Option D
• C.Option A
• D.Option C

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 the two original observations as the where clause does not work.
• B.No report is generated as the case of the compared values is different.
• C.A report is generated with one destination.
• D.No report is generated as the case of the macro variable name is different.

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

This question will ask you to provide a segment of missing code.
Given data sets ONE and TWO with the same variables, the following SAS program is submitted:

In the text below, complete the following program so that it will produce the same results as the above program:

Case is ignored and standard SAS syntax rules apply.

The following SAS program is submitted:
% let dept=prod;
% let prod=merchandise;
The following message is written to the SAS log:
The value is "merchandise"
Which SAS System option writes this message to the SAS log?

• A.%put the value is "&&&dept";
• B.%put the value is "&&&dept";
• C.%put the value is "&&&dept";
• D.%put the value is %quote (&&&dept);