SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 101:

  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. KEEP/DROP

  B. WHERE

  C. CASE

  D. IF/THEN/ELSE

  Correct Answer: A

• Question 102:

  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

  Correct Answer: D

• Question 103:

  The following SAS program is submitted:

  options reuse=YES;

  data sasuser RealEstate(compress=CHAR);

  set sasuser houses;

  run;

  What is the effect of the REUSE=YES SAS system option?

  A. It tracks and recycles free space

  B. It allows a permanently stored SAS data set to be replaced

  C. It allows users to access the same SAS data set concurrently

  D. It allows updates in place

  Correct Answer: A

• Question 104:

  Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

  A. OBS=pointobs

  B. POINT=pointobs

  C. KEY=pointobs

  D. NOBS=pointobs

  Correct Answer: B

• Question 105:

  Given the following SAS program:

  proc sql;

  select product, type, sum(sales) as revenue

  from one

  group by product, type;

  quit;

  Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

  A. order by 1, 3

  B. order by 1, 3 desc

  C. orderby product, revenue desc

  D. order by product, desc revenue

  Correct Answer: B

• Question 106:

  The following SAS program is submitted:

  %micro test(var);

  %let jobs=BLACKSMITH WORDSMITH SWORDSMITH;

  %let type=%index(andjobs, andvar);

  %put type = andtype;

  %mend;

  %test(SMITH)

  What is the value of the macro variable TYPE when the %PUT statement executes?

  A. 0

  B. Null

  C. 6

  D. 3

  Correct Answer: C

• Question 107:

  Given the following SAS data set ONE:

  ONE

  GROUP SUM

  A 765

  B 123

  C 564

  The following SAS program is submitted:

  data _null_;

  set one;

  call symput(group,sum);

  run;

  Which one of the following is the result when the program finishes execution?

  A. Macro variable C has a value of 564.

  B. Macro variable C has a value of 1452.

  C. Macro variable GROUP has a value of 564.

  D. Macro variable GROUP has a value of 1452.

  Correct Answer: A

• Question 108:

  Given the following SAS program:

  

  What will be the output from the PRINT Procedure?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 109:

  Given the two output sets shown on the left, which program produced the output shown on the right?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

  Reference: http://web.utk.edu/sas/OnlineTutor/1.2/en/60477/m71/m71_26.htm

• Question 110:

  The following SAS program is submitted:

  

  What is the value of the macro variable Newval when the %PUT statement executes?

  A. 0.555

  B. 2.2

  C. 1

  D. 2

  Correct Answer: C

  %PUT statement shows that %EVAL discards the fractional part when it performs division on integers that would result in a fraction.