SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 141:

  This question will ask you to provide a missing reference. Given the SAS data set SASUSER HIGHWAY:

  

  The following SAS program is submitted: What macro variable reference completes the program to create the WORK.NOT and WORK SERIOUS data sets?

  

  A. and Status and Count

  B. and and Status and i

  C. and and Status and Count

  D. and Status and i

  Correct Answer: B

• Question 142:

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

  The following SAS program is submitted:

  %let lib = %upcase(sasuser);

  proc sql;

  select nvar

  from dictionary.tables

  where libname = "andlib";

  quit;

  Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

  A. no result set

  B. a syntax error in the log

  C. a report showing the names of each table in SASUSER

  D. a report showing the number of columns in each table in SASUSER

  Correct Answer: D

• Question 144:

  Which one of the following techniques concatenates data in SAS?

  A. the APPEND procedure

  B. the DATA step with a MERGE statement

  C. the DATA step with a COMBINE statement

  D. the INTERSECT operator in the SQL procedure

  Correct Answer: A

• Question 145:

  The SAS data set ONE contains the variables X, Y, Z, and W.

  The following SAS program is submitted:

  proc transpose data = one

  out = trans

  name = new;

  by x;

  var y;

  run;

  Which one of the following contains all the names of the columns created by the

  TRANSPOSE procedure?

  A. X, Y, Z, and W

  B. _NAME_, X, and Y

  C. new, X, and COL1

  D. new, X, Y, and _COL1_

  Correct Answer: C

• Question 146:

  The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE?

  A. data two; set three; set one key = X; run;

  B. data two; set three key = X; set one; run;

  C. data two; set one; set three key = X; run;

  D. data two; set three; set one (key = X); run;

  Correct Answer: A

• Question 147:

  Which PUT statements will be the log if the program is submitted at the beginning of a new SAS session?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 148:

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

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  NUM CHAR1 NUM CHAR2

  1 A 2 X 2 B 3 Y

  4 D 5 V

  The following SAS program is submitted creating the output table THREE:

  data three;

  set one two;

  run;

  THREE

  NUM CHAR1 CHAR2

  1 A

  2 B

  4 D

  2 X

  3 Y

  5 V

  Which one of the following SQL programs creates an equivalent SAS data set THREE?

  A. proc sql; create table three as select * from one outer union corr select * from two; quit;

  B. proc sql; create table three as select * from one outer union select * from two; quit;

  C. proc sql; create table three as select * from one outer union select * quit;

  D. proc sql; create table three as select * from one union corr select * from two; quit;

  Correct Answer: A

• Question 150:

  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