SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 101:

  Which one of the following should be avoided when creating and using an SQL procedure view?

  A. using a HAVING clause
  B. using summary functions
  C. referencing a view multiple times in the same program
  D. creating views on tables whose structures remain constant
  C. referencing a view multiple times in the same program

• Question 102:

  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
  A. It tracks and recycles free space

• Question 103:

  Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

  A. NODUP
  B. UNIQUE
  C. DISTINCT
  D. NODUPKEY
  A. NODUP

• Question 104:

  Given the following SAS data set ONE: ONE LEVEL AGE 1 10 2 20 3 20 2 10 1 10 2 30 3 10 2 20 3 30 1 10 The following SAS program is submitted: proc sql; select level, max(age) as MAX from one

  group by level

  having max(age) > (select avg(age) from one);

  quit;

  Which one of the following reports is generated?

  A. LEVEL AGE 2 20 3 20
  B. LEVEL AGE 2 30 3 30
  C. LEVEL MAX 2 20 3 30
  D. LEVEL MAX 2 30 3 30
  D. LEVEL MAX 2 30 3 30

• Question 105:

  Given the following partial SAS log:

  

  Which SQL procedure statement generated this output?

  A. DECREASE TABLE SASHELP.CLASS;
  B. CONTENTS TABLE SASHELP.CLASS;
  C. DESCRIBE TABLE=SASHELP.CLASS;
  D. ATTRIBUTE TABLE=SASHELP.CLASS
  C. DESCRIBE TABLE=SASHELP.CLASS;

• 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?

  B. Null
  C. 6
  D. 3
  C. 6

• Question 107:

  The following SAS program is submitted:

  options mprint;

  %macro test(parm);

  proc andparm data = sashelp.prdsale;

  run;

  %mend;

  %test(print)

  What is the result of the MPRINT options?

  A. It has no effect in this example
  B. It writes the original program code inside the marco definition to the SAS log
  C. It writes macro execution messages to the SAS.log
  D. It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log
  D. It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log

• Question 108:

  Given a data set with the following characteristics:

  50000 observations 200 character variables

  In the text below, enter the compression option that will provide the most compression Case is ignored and standard SAS syntax rules apply.

  CHAR

  The YES or CHAR setting for the COMPRESS= option uses the RLE compression algorithm. RLE compresses observations by reducing repeated consecutive characters (including blanks) to two-byte or three-byte representations. Therefore, RLE is most often useful for character data that contains repeated blanks. The YES or CHAR setting is also good for compressing numeric data in which most of the values are zero

• Question 109:

  The SAS data set WORK.TEMP is indexed on variable Id:

  

  The following SAS program is submitted:

  

  A. Stops because the data is not descending order
  B. Generates a report without a problem
  C. Stops because the data is not in ascending order
  D. Generates a report, but only if the index = USE option is turned on
  A. Stops because the data is not descending order

• Question 110:

  The following SAS program is submitted:

  %let first=yourname;

  %let last=first;

  %put andandandlast;

  What is written to the SAS Log?

  A. First
  B. Yourname
  C. andandFirst
  D. andyourname
  B. Yourname