SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 1:

  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 2:

  The following SAS program is submitted:

  %macro test(var);

  proc print data = sasuser.class;

  where age > andvar;

  run;

  %mend;

  Which type of parameter is the macro variable VAR?

  A. default
  B. keyword
  C. positional
  D. command
  C. positional

• Question 3:

  When is it appropriate to create indexes on a SAS data set for efficient processing?

  A. if small subsets of data are often retrieved
  B. if the key variable has very few unique values
  C. if the data are often used for BY group processing
  D. if the SAS data set file page count is less than three pages
  A. if small subsets of data are often retrieved

• Question 4:

  Given the following SAS data set ONE:

  ONE

  CATEGORY AGE SALARY BONUS

  ------------------------------------------------------- M 28 200 20

  M 25 100 10

  M 28 300 10

  M 33 300 30

  F 18 100 50

  F 25 200 10

  F 35 50

  The following SAS program is submitted:

  proc sql;

  select distinct category,

  sum(sum(salary,bonus)) as EARNINGS

  from one

  where age < 30

  group by category

  having calculated EARNINGS < 500;

  quit;

  Which one of the following reports will be generated?

  A. CATEGORY EARNINGS F 360
  B. CATEGORY EARNINGS M 640 F 360
  C. CATEGORY EARNINGS F 150 F 210
  D. CATEGORY EARNINGS M 220 M 110 M 310 F 150 F 210
  A. CATEGORY EARNINGS F 360

• Question 5:

  Given the following SAS data set ONE:

  ONE DIVISION SALES

  A 1234

  A 3654

  B 5678

  The following SAS program is submitted:

  data _null_;

  set one;

  by division;

  if first.division then

  call symput('mfirst',sales);

  if last.division then

  call symput('mlast',sales);

  run;

  Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

  A. null
  B. 1234
  C. 3654
  D. 5678
  D. 5678

• Question 6:

  The following SAS program is submitted:

  data temp;

  array points{2,3}_temporary_;

  run;

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

  A. 2
  B. 3
  C. 5
  D. 6
  D. 6

• Question 7:

  The following SAS program is submitted:

  %macro test(var);

  %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;

  %let type = %index(andjobs,andvar);

  %mend;

  %test(SMITH)

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

  B. 3
  C. 6
  D. null
  C. 6

• Question 8:

  The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES

  OBS STYLE

  1 RANCH

  2 SPLIT

  3 CONDO

  4 TWOSTORY

  5 RANCH

  6 SPLIT

  7 SPLIT

  The following SAS program is submitted:

  proc sql noprint;

  select distinct style

  into :styles separated by ' '

  from sasuser.houses

  order by style;

  quit;

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

  A. CONDO RANCH SPLIT TWOSTORY
  B. RANCH SPLIT CONDO TWOSTORY
  C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
  D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT
  A. CONDO RANCH SPLIT TWOSTORY

• Question 9:

  Which one of the following statements is true regarding a SAS DATA step view?

  A. It allows write capabilities.
  B. It contains global statements.
  C. It contains data and a descriptor portion.
  D. It contains a partially compiled DATA step.
  D. It contains a partially compiled DATA step.

• Question 10:

  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.