A00-212

A00-212 practice questions, page 6 of 8, with answer review and explanations.

Question 26

What is the purpose of the SASFILE statement?

  1. It requests that SAS data set be opened and loaded into SAS memory one page at a time
  2. It requests that a SAS data set the opened and loaded into SAS memory one variable at a time
  3. It requests that a SAS data set be opened and loaded into SAS memory one observation at a time
  4. It requests that a SAS data set be opened and loaded into SAS memory in its entirety

Question 27

Given the SAS date sets CLASS1 and CLASS2 CLASS1 CLASS2 - NAME COURSE NAME COURSE - Lauren MATH1 Smith MATH2 - Patel MATH1 Farmer MATH2 - Chang MATH1 Patel MATH2 - Chang MATH3 Hiller MATH2 - The following SAS program is submitted: Proc sql; Select name from CLASS1 - select name from CLASS; quit; The following output is desired - NAME - Chang - Chang - Lauren - Which SQL set operator completes the program and generates the desired output?

  1. UNION ALL
  2. EXCEPT ALL
  3. INTERSECT ALL
  4. OUTER UNION ALL

Question 28

The following SAS program is submitted: data new (bufnp=4); set old(bufno=4); run; Why are the BUFNO options used?

  1. To reduce the number I/O operations
  2. To reduce network traffic
  3. To reduce memory usage
  4. To reduce the amount of data read

Question 29

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?

  1. It tracks and recycles free space
  2. It allows a permanently stored SAS data set to be replaced
  3. It allows users to access the same SAS data set concurrently
  4. It allows updates in place

Question 30

The SAS data set ONE contains fifty million observations and contains the variable PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

  1. data two; Set one; Where totrev>1000; Totrev=sum(price*quantity); Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;
  2. data two; Set one; totrev=sum(price*quantity); where totrev>1000; totcost=sum(fixed,variable); profit=sum(totrev,-totcost); run;
  3. data two; Set one; Totrev=sum(price*quantity); If totrev>1000; Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;
  4. data two; Set one; Totrev = sum(price*quantity); Totcost= sum(fixed,variable); If totrev>1000; Profit=sum(totrev,-totcost);