SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 141:

  Given the non-indexed SAS data set TEMP: TEMP X Y

  P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: Proc print data=temp; run; Which BY statement completes the program, creates a listing report that is grouped by X and completes without errors?

  A. By X notsorted;
  B. By X grouped;
  C. By Descending X;
  D. By X;
  A. By X notsorted;

• Question 142:

  The following SAS program is submitted:

  %let test=one;

  %let one=two;

  %let two=three;

  %let three=last;

  %put what displays is andandandandandtest;

  What is the written to the SAS log?

  A. What displays is three
  B. What displays is two
  C. What displays is one
  D. What displays is last
  B. What displays is two

• Question 143:

  The following SAS program is submitted:

  %let a = cat;

  %macro animal(a = frog);

  %let a = bird;

  %mend;

  %animal(a = pig)

  %put a is anda;

  Which one of the following is written to the SAS log?

  A. a is anda
  B. a is cat
  C. a is pig
  D. a is bird
  B. a is cat

• Question 144:

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

  

  What will be output by the program?

  A. ERROR: Subquery evaluated to more than one row
  B. Average of Employment 6
  C. Average of Employment 5
  D. Average of employment 7
  C. Average of Employment 5

• Question 145:

  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.
  A. Macro variable C has a value of 564.

• Question 146:

  Which one of the following SAS programs uses the most amount of memory resources for output buffers?

  A. data new(bufsize = 1000 bufno = 5); set temp; run;
  B. data new(bufsize = 1000 bufno = 2); set temp; run;
  C. data new(bufsize = 2000 bufno = 3); set temp; run;
  D. data new(bufsize = 4000 bufno = 1); set temp; run;
  C. data new(bufsize = 2000 bufno = 3); set temp; run;

• Question 147:

  The following SAS program is submitted:

  data one;

  do i = 1 to 10;

  ptobs = ceil(ranuni(0) * totobs);

  set temp point = ptobs

  nobs = totobs;

  output;

  end;

  stop;

  run;

  The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

  A. any integer between 1 and 10
  B. any real number between 0 and 1
  C. any integer between 1 and 2,500,000
  D. any real number between 1 and 2,500,000
  C. any integer between 1 and 2,500,000

• Question 148:

  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
  C. Option C

• Question 149:

  The question will ask you to provide a segment of missing code. The following SAS program is submitted:

  

  The text box above, complete the %PUT statement to produce the following log output:

  Case is ignored and standard SAS syntax rules apply.

  _sample_

• Question 150:

  Which one of the following is true regarding the KEEP statement?

  A. The KEEP statement is available in both the DATA and the PROC steps.
  B. The KEEP statement selects the variables read from the input data set(s).
  C. The KEEP statement applies to all data sets created within the same DATA step.
  D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.
  C. The KEEP statement applies to all data sets created within the same DATA step.