SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 31:

  The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

  A. Define index (Id_Code) in WORK.CHECK;
  B. Create index (Id_Code) on WORK.CHECK;
  C. Make index = Id_Code from WORK.CHECK;
  D. Create index Id_Code on WORK.CHECK;
  D. Create index Id_Code on WORK.CHECK;

• Question 32:

  The following SAS program is submitted: data new (bufsize = 6144 bufno = 4);

  set old;

  run;

  Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

  A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.
  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.
  C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.
  D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.
  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

• Question 33:

  The following SAS program is submitted:

  

  What is written to the SAS log?

  A. Mv is bicycle
  B. Mv is shoes
  C. Mv is tents
  D. Mv is clothes
  B. Mv is shoes

• Question 34:

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

  

  Which segment of code will successfully run an in-line view?

  

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

• Question 35:

  Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?

  A. DICTIONARY.COLUMNS
  B. DICTIONARY.VARIABLES
  C. DICTIONARY.MEMBERS
  D. DICTIONARY.TABLES
  A. DICTIONARY.COLUMNS

• Question 36:

  Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

  A. %let start = today(),weekdate.;
  B. %let start = today(),format=weekdate.;
  C. %let start = %sysfunc(today(),weekdate.);
  D. %let start = %sysfunc(%today(),weekdate.);
  C. %let start = %sysfunc(today(),weekdate.);

• Question 37:

  The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

  proc sort data=WORK.CHECK;

  by Code;

  run;

  What describes the result of submitting SAS program?

  A. The index on Code is updates
  B. The sort does not execute
  C. The index on Code is deleted
  D. The index on the Code unaffected
  B. The sort does not execute

• Question 38:

  The following SAS program is submitted:

  options yearcutoff = 1950;

  %macro y2kopt(date);

  %if anddate >= 14610 %then %do;

  options yearcutoff = 2000;

  %end;

  %else %do;

  options yearcutoff = 1900; %end;

  %mend;

  data _null_ ;

  date = "01jan2000"d;

  call symput("date",left(date));

  run;

  %y2kopt(anddate)

  The SAS date for January 1, 2000 is 14610 and the SAS system option for

  YEARCUTOFF is set to 1920 prior to submitting the above program.

  Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

  A. 1900
  B. 1920
  C. 1950
  D. 2000
  D. 2000

• Question 39:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted;

  

  Which result set would be generated?

  

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

• Question 40:

  The following SAS program is submitted:

  data two;

  y = '2';

  run;

  %let x = 10;

  %let var = y;

  data one;

  set two (keep = andvar);

  z = andvar * andx;

  run;

  Which one of the following is the value of the variable Z when the program finishes execution?

  A. _ERROR_
  B. 20 (as a numeric)
  C. 20 (as a character)
  D. . (missing numeric)
  B. 20 (as a numeric)