SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 51:

  What is generated as a result of submitting the RANUNI function with a seed of 123?

  A. A missing value because 123 is an invalid argument for the RANUNI function
  B. A different sequence of random numbers with each program execution
  C. A random number between 0 and 123
  D. A consistent sequence of random numbers with each program execution
  D. A consistent sequence of random numbers with each program execution

• Question 52:

  Which SAS produce can be used to report Page Size?

  A. PRINT Procedure
  B. CATALOG Procedure
  C. REPORT Procedure
  D. CONTENTS Procedure
  C. REPORT Procedure

• Question 53:

  Which MACRO option is responsible for this partial SAS log?

  

  A. MAUTOLOCDISPLAY
  B. MLOGIC
  C. MPRINTNEST
  D. MPRINT
  B. MLOGIC

• Question 54:

  Given the data set shown on the left, the SAS program on the right is submitted: Which statement is true regarding the WORK.MISSING data set?

  

  A. The descriptor portion of WORK.MISSING is created when the DATA step is submitted
  B. The data set is created when the DATA step is submitted
  C. When the view ONE is used in another SAS step, the data set is created
  D. The data set not created because the DATA statement contains a syntax error
  D. The data set not created because the DATA statement contains a syntax error

• Question 55:

  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
  B. POINT=pointobs

• Question 56:

  The following SAS program is submitted:

  %let value = 9;

  %let value2 = 5;

  %let newval = %eval(andvalue / andvalue2);

  Which one of the following is the resulting value of the macro variable NEWVAL?

  A. 1
  B. 2
  C. 1.8
  D. null
  A. 1

• Question 57:

  This item will ask you to provide a segment of missing code.

  Given the input data set shown on the left and the output data set shown on the right:

  

  In the text below, enter the code that will complete the program to produce the output set shown above on the right.

  Case is ignored and standard SAS syntax rules apply.

  N

• Question 58:

  Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?

  A. DATASETS
  B. MODIFY
  C. FORMAT
  D. REGISTRY
  A. DATASETS

• Question 59:

  Given the data set SASHELP.CLASS SASHELP.CLASS NAME AGE Mary 15 Philip 16 Robert 12 Ronald 15 The following SAS program is submitted %let value = Philip; proc print data =sashelp.class; run; Which WHERE statement successfully completes the program and produces a report?

  A. Where upcase(name)="upcase(andvalue)";
  B. Where upcase(name)="%upcase(andvalue)";
  C. Where upcase(name)=upcase(andvalue);
  D. Where upcase(name)=%upcase(andvalue);
  B. Where upcase(name)="%upcase(andvalue)";

• Question 60:

  The following SAS program is submitted:

  %let lib = %upcase(sasuser);

  proc sql;

  select nvar

  from dictionary.tables

  where libname = "andlib";

  quit;

  Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

  A. no result set
  B. a syntax error in the log
  C. a report showing the names of each table in SASUSER
  D. a report showing the number of columns in each table in SASUSER
  D. a report showing the number of columns in each table in SASUSER