SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 161:

  Which SAS System option(s) can aid in benchmarking?

  A. SYSTIMER
  B. IOBLOCKSIZE=
  C. BUFSIZE = and BUFNO=
  D. FULLSTIMER
  D. FULLSTIMER

• Question 162:

  Which one of the following techniques concatenates data in SAS?

  A. the APPEND procedure
  B. the DATA step with a MERGE statement
  C. the DATA step with a COMBINE statement
  D. the INTERSECT operator in the SQL procedure
  A. the APPEND procedure

• Question 163:

  The following SAS ARRAY statement is submitted:

  array score{*} a4 - a10, a25 ;

  Which one of the following is the maximum number of elements stored?

  A. 3
  B. 7
  C. 8
  D. 11
  C. 8

• Question 164:

  The following SAS program is submitted:

  %macro location;

  data _null_;

  call symput ('dept','sales');

  run;

  %let country=Germany;

  %put_global_;

  %mend;

  %let company = ABC;

  %location;

  Which macro variables are written to the SAS log?

  A. COMPANY and DEPT only
  B. COMPANY, COUNTRY and DEPT
  C. COMPANY Only
  D. COMPANY and COUNTRY only
  A. COMPANY and DEPT only

• Question 165:

  Given the SAS dataset ONE

  ONE

  SALARY

  The following SAS program is submitted

  Proc sql;

  Select * from one

  ;

  quit;

  The following output is desired:

  SALARY

  Which WHERE expression completes the program and generates the desired output?

  A. Where salary is not
  B. Where salary ne null
  C. Where salary is not missing
  D. Where salary ne missing
  C. Where salary is not missing

• Question 166:

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

  

  What will be the result when this program is executed?

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

• Question 167:

  Given the following SAS data sets ONE and TWO: ONE TWO

  YEAR QTR BUDGET YEAR QTR SALES

  2001 3 500 2001 4 300

  2001 4 400 2002 1 600

  2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one, two;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600
  B. YEAR QTR BUDGET SALES 2001 3 500 2001 4 400 300 2002 1 700 600
  C. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600

• Question 168:

  Following SAS program is submitted:

  data temp();

  infile 'rawdata';

  input x $ y z;

  run;

  RAWDATA is a file reference to an external file that is ordered by the variable X.

  Which option specifies how the data in the SAS data set TEMP will be sorted?

  A. ORDEREDBY=X
  B. GROUPBY=X
  C. SORTEDBY=X
  D. SORTSYNC=X
  C. SORTEDBY=X

• Question 169:

  The following SAS program is submitted:

  

  The current system date macro variable is 30JUL2013. Which output will be written to the log by the program?

  A. In two years it will be: 2014+1
  B. Error: Required operator not found in expression in two years it will be: 2013+12+1
  C. In two years it will be: 2013+1+1+1
  D. In two years it will be: 2014+1+1
  D. In two years it will be: 2014+1+1

• Question 170:

  Which one of the following options displays the value of a macro variable in the SAS log?

  A. MACRO
  B. SOURCE
  C. SOURCE2
  D. SYMBOLGEN
  D. SYMBOLGEN