SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 71:

  The following SAS code is submitted:

  %macro houses(dsn = houses,sub = RANCH);

  data anddsn;

  set sasuser.houses;

  if style = "?quot;;

  run;

  %mend;

  %houses(sub = SPLIT)

  %houses(dsn = ranch)

  %houses(sub = TWOSTORY)

  Which one of the following is the value of the automatic macro variable SYSLAST?

  A. work.ranch

  B. work.houses

  C. WORK.RANCH

  D. WORK.HOUSES

  Correct Answer: D

• Question 72:

  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 400 50

  The following SQL program is submitted:

  proc sql;

  create table two as

  select distinct age

  from one

  where age < 33;

  quit;

  How many rows are written to the SAS data set TWO?

  A. 3

  B. 4

  C. 5

  D. 6

  Correct Answer: A

• Question 73:

  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

  Correct Answer: C

  Reference: http://www.sascommunity.org/wiki/Macro_CallText

• Question 74:

  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

  Correct Answer: D

• Question 75:

  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

  Correct Answer: A

• Question 76:

  Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

  A. proc datasets lib = sasuser.all; quit;

  B. proc datasets lib = sasuser._all_; quit;

  C. proc datasets lib = sasuser; contents data = all; quit;

  D. proc datasets lib = sasuser; contents data = _all_; quit;

  Correct Answer: D

• Question 77:

  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)

  Correct Answer: B

• Question 78:

  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

  Correct Answer: D

• Question 79:

  Given the following SAS data set ONE:

  ONE NUM VAR 1 A 2 B 3 C Which one of the following SQL programs deletes the SAS data set ONE?

  A. proc sql; delete table one; quit;

  B. proc sql; alter table one drop num, var; quit;

  C. proc sql; drop table one; quit;

  D. proc sql; delete from one; quit;

  Correct Answer: C

• Question 80:

  The following SAS FORMAT procedure is submitted:

  proc format lib = sasuser;

  value tempc low < 0 = 'BELOW FREEZING'

  0 < 5 = 'COLD'

  5 < 10 = 'MILD'

  10 < 15 = 'WARM'

  15 high = 'HOT';

  run;

  How is the value 10 displayed when the format TEMPC is applied?

  A. 10

  B. MILD

  C. WARM

  D. BELOW FREEZING

  Correct Answer: C