SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 51:

  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

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

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

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

  The following SAS program is submitted:

  %let value = .5;

  %let add = 5;

  %let newval = %eval(andvalue + andadd);

  Which one of the following is the resulting value of the macro variable NEWVAL?

  A. 5

  B. 5.5

  C. .5 + 5

  D. null

  Correct Answer: D

• Question 55:

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

  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

• Question 57:

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

  A. MLOGIC

  B. MDEBUG

  C. MSGLEVEL

  D. MAUTOSOURCE

  Correct Answer: A

• Question 58:

  The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES

  OBS STYLE

  1 RANCH

  2 SPLIT

  3 CONDO

  4 TWOSTORY

  5 RANCH

  6 SPLIT

  7 SPLIT

  The following SAS program is submitted:

  proc sql noprint;

  select distinct style

  into :styles separated by ' '

  from sasuser.houses

  order by style;

  quit;

  Which one of the following is the value of the resulting macro variable?

  A. CONDO RANCH SPLIT TWOSTORY

  B. RANCH SPLIT CONDO TWOSTORY

  C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY

  D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

  Correct Answer: A

• Question 59:

  Given the following SAS data set ONE:

  ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400

  The following SAS data set TWO is created:

  TWO JOB LEVEL BONUS

  ACC 2 30 MGR 3 70 MGR 2 40

  Which one of the following SAS programs creates data set TWO?

  A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;

  B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;

  C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;

  D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;

  Correct Answer: D

• Question 60:

  Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?

  A. MPRINT

  B. MLOGIC

  C. MSOURCE

  D. SOURCE2

  Correct Answer: A