SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 71:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first

  B. andfirst

  C. yourname

  D. andyourname

  Correct Answer: C

• Question 72:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  YEAR QTR BUDGET YEAR QTR SALES

  ----------------------------- ------------------------------ 2001 3 500 2001 4 300

  2001 4 400 2002 1 600

  2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one left join two

  on one.year = two.year;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES

  2001 3 500 .

  B. YEAR QTR BUDGET SALES

  2001 4 400 300

  2002 1 700 600

  C. YEAR QTR BUDGET SALES

  2001 3 50 .

  2001 4 400 300

  2002 1 700 600

  D. YEAR QTR BUDGET SALES

  2001 3 500 300

  2001 4 400 300

  2002 1 700 600

  Correct Answer: D

• Question 73:

  The following SAS program is submitted:

  proc sql;

  select *

  from dictionary.tables;

  quit;

  Which one of the following is reported?

  A. metadata on all tables in all libraries

  B. metadata on all tables in the WORK library only

  C. metadata on all tables in the SASUSER library only

  D. metadata on all tables in the DICTIONARY library only

  Correct Answer: A

• Question 74:

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

  The following SAS program is submitted:

  %let a = cat;

  %macro animal(a = frog);

  %let a = bird;

  %mend;

  %animal(a = pig)

  %put a is anda;

  Which one of the following is written to the SAS log?

  A. a is anda

  B. a is cat

  C. a is pig

  D. a is bird

  Correct Answer: B

• Question 76:

  The DICTIONARY.MACROS table stores information about which of the following?

  A. user defined macro variables only

  B. system defined macro variables only

  C. both user and system defined macro variables

  D. macros stored in the autocall macro library only

  Correct Answer: C

• Question 77:

  Given the following SAS data set named WORK.INTERNAT:

  WORK.INTERNAT LOCATION SUM

  USA 30

  EUR 40

  The following SAS program is submitted:

  %let LOC = Usa;

  proc sql;

  select *

  from internat

  where location = "andLoc";

  quit;

  Which one of the following is the result when the above code is executed on the above data set?

  A. A report is generated with one destination.

  B. No report is generated as the case of the compared values is different.

  C. No report is generated as the case of the macro variable name is different.

  D. A report is generated with the two original observations as the where clause does not work.

  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:

  Which one of the following is the purpose of the IDXNAME= data set option?

  A. It instructs SAS to name and store a specific index.

  B. It instructs SAS to store an index in a particular location.

  C. It instructs SAS to use a specific index for WHERE processing.

  D. It instructs SAS to use any available index for WHERE processing.

  Correct Answer: C

• Question 80:

  Which one of the following is true regarding the KEEP statement?

  A. The KEEP statement is available in both the DATA and the PROC steps.

  B. The KEEP statement selects the variables read from the input data set(s).

  C. The KEEP statement applies to all data sets created within the same DATA step.

  D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.

  Correct Answer: C