SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 81:

  Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

  A. ECHOVIEW option

  B. EXPANDVIEW option

  C. VALIDATE VIEW statement

  D. DESCRIBE VIEW statement

  Correct Answer: D

• Question 82:

  Given the following SAS data set ONE:

  ONE LEVEL AGE

  1 10 2 20

  3 20

  2 10

  1 10

  2 30

  3 10

  2 20

  3 30

  1 10

  The following SAS program is submitted:

  proc sql;

  select level, max(age) as MAX

  from one group by level

  having max(age) > (select avg(age) from one);

  quit;

  Which one of the following reports is generated?

  A. LEVEL AGE

  2 20

  3 20

  B. LEVEL AGE

  2 30

  3 30

  C. LEVEL MAX

  2 20

  3 30

  D. LEVEL MAX

  2 30

  3 30

  Correct Answer: D

• Question 83:

  Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

  A. It temporarily compresses observations in a SAS data set.

  B. It allows users to update the same SAS data set concurrently.

  C. It allows new observations to be inserted wherever enough free space exists.

  D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.

  Correct Answer: C

• Question 84:

  The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ;

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

  A. 3

  B. 7

  C. 8

  D. 11

  Correct Answer: C

• Question 85:

  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

  Correct Answer: A

• Question 86:

  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

  Correct Answer: D

• Question 87:

  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?

  A. 0

  B. 3

  C. 6

  D. null

  Correct Answer: C

• Question 88:

  Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

  A. CHECK

  B. UNIQUE

  C. FORMAT

  D. DISTINCT

  Correct Answer: A

• Question 89:

  Which one of the following options displays the value of a macro variable in the SAS log?

  A. MACRO

  B. SOURCE

  C. SOURCE2

  D. SYMBOLGEN

  Correct Answer: D

• Question 90:

  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.);

  Correct Answer: C