SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 61:

  Which one of the following should be avoided when creating and using an SQL procedure view?

  A. using a HAVING clause

  B. using summary functions

  C. referencing a view multiple times in the same program

  D. creating views on tables whose structures remain constant

  Correct Answer: C

• Question 62:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM COUNTRY NUM CITY

  1 CANADA 3 BERLIN

  2 FRANCE 5 TOKYO

  3 GERMANY 4 BELGIUM

  5 JAPAN

  The following SAS program is submitted:

  proc sql;

  select country from one where not exists

  (select * from two where one.num = two.num);

  quit;

  Which one of the following reports is generated?

  A. COUNTRY

  GERMANY

  JAPAN

  B. COUNTRY

  FRANCE

  BELGIUM

  C. COUNTRY

  CANADA

  FRANCE

  BELGIUM

  D. COUNTRY

  CANADA

  FRANCE

  GERMANY

  Correct Answer: C

• Question 63:

  Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

  A. andRC

  B. andERR

  C. andSYSRC

  D. andSYSERR

  Correct Answer: D

• Question 64:

  Which one of the following statements is true?

  A. The WHERE statement can be executed conditionally as part of an IF statement.

  B. The WHERE statement selects observations before they are brought into the PDV.

  C. The subsetting IF statement works on observations before they are read into the PDV.

  D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

  Correct Answer: B

• Question 65:

  The following SAS program is submitted:

  proc datasets lib = testdata;

  modify one;

  label num = 'Number';

  format num 4.;

  quit;

  Which one of the following SQL programs produces the same results as the above DATASETS procedure?

  A. proc sql; modify table testdata.one num format = 4. label = 'Number'; quit;

  B. proc sql;

  alter table testdata.one

  modify num format = 4.

  label = 'Number';

  quit;

  C. proc sql; modify table testdata.one alter num format = 4. label = 'Number'; quit;

  D. proc sql; alter table testdata.one modify num (format = 4. label = 'Number'); quit;

  Correct Answer: B

• Question 66:

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

  Given the following SAS program:

  proc sql;

  select product, type, sum(sales) as revenue

  from one

  group by product, type;

  quit;

  Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

  A. order by 1, 3

  B. order by 1, 3 desc

  C. orderby product, revenue desc

  D. order by product, desc revenue

  Correct Answer: B

• Question 68:

  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

  Correct Answer: C

• Question 69:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  OBS COMMON X OBS COMMON Y

  ---------------------------- ------------------------------ 1 A 10 1 A 1

  2 A 13 2 A 3

  3 A 14 3 B 4

  4 B 9 4 B 2

  5 C 8 5 C 5

  6 C 14

  The following SAS DATA step is submitted:

  data combine;

  set one;

  set two;

  run;

  Which one of the following represents the data values stored in data set COMBINE?

  A. OBS COMMON X Y

  1 A 10 1

  2 A 13 3

  3 A 14 3

  4 B 9 4

  5 B 9 2

  6 C 8 5

  7 C 14 5

  B. OBS COMMON X Y

  1 A 10 1

  2 A 13 3

  3 B 9 4

  4 C 8 5

  C. OBS COMMON X Y

  1 A 10 1

  2 A 13 3

  3 B 14 4

  4 B 9 2

  5 C 8 5

  D. OBS COMMON X Y

  1 A 10 1

  2 A 13 1

  3 A 14 1

  4 A 10 3

  5 A 13 3

  6 A 14 3

  7 B 9 4

  8 B 9 2

  9 C 8 5

  10 C 14 5

  Correct Answer: C

• Question 70:

  Which one of the following options is available for SAS macro debugging?

  A. MLOGIC

  B. MDEBUG

  C. MSGLEVEL

  D. MAUTOSOURCE

  Correct Answer: A