SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 91:

  Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?

  A. DATASETS

  B. MODIFY

  C. FORMAT

  D. REGISTRY

  Correct Answer: A

• Question 92:

  The following SAS program is submitted:

  data temp;

  array points{2,3} (10,15,20,25,30,35);

  run;

  What impact does the ARRAY statement have in the Program Data Vector(PDV)?

  A. No variable are created in the PDV

  B. The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV

  C. The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV

  D. The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV

  Correct Answer: C

• Question 93:

  The following SAS program is submitted:

  data new;

  do i=1,2,3

  nextfile=compress('March' || |);

  infile abc filevar=nextfile

  end=eof;

  do until (eof);

  input dept $sales;

  end;

  run;

  What is the purpose of the FILEVAR=option on the INFILE statement?

  A. It names the variable NEXTFILE, whose value is output to the SAS data set NEW

  B. It names the variable NEXTFILE, whose values point to an aggregate storage location

  C. It names the variable NEXTFILE, whose value is a SAS file reference

  D. It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file

  Correct Answer: D

• Question 94:

  Which option forces the use of a specific index from a data set?

  A. INDEX

  B. IDXNAME

  C. IDXWHERE

  D. INDEX

  Correct Answer: B

  Reference:

  http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a00044 0261.htm (search for IDXNAME)

• Question 95:

  Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?

  A. DICTIONARY.COLUMNS

  B. DICTIONARY.VARIABLES

  C. DICTIONARY.MEMBERS

  D. DICTIONARY.TABLES

  Correct Answer: A

• Question 96:

  Given the SAS data set WORK TRANSACT:

  

  The following output is desired:

  

  Which SQL statement was used?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 97:

  Given the following SAS data set ONE:

  ONE

  REP COST

  SMITH 200

  SMITH 400

  JONES 100

  SMITH 600

  JONES 100

  JONES 200

  JONES 400

  SMITH 800

  JONES 100

  JONES 300

  The following SAS program is submitted:

  proc sql;

  select rep, avg(cost) as AVERAGE

  from one

  group by rep

  having avg(cost) > (select avg(cost) from one);

  quit;

  Which one of the following reports is generated?

  A. REP AVERAGE JONES 200

  B. REP AVERAGE JONES 320

  C. REP AVERAGE SMITH 320

  D. REP AVERAGE SMITH 500

  Correct Answer: D

• Question 98:

  The following SAS program is submitted:

  %let dept=prod;

  %let prod=merchandise;

  The following message is written to the SAS log:

  The value is "merchandise"

  Which SAS System option writes this message to the SAS log?

  A. %put the value is "andandanddept";

  B. %put the value is "andandanddept";

  C. %put the value is "andandanddept";

  D. %put the value is %quote (andandanddept);

  Correct Answer: A

• Question 99:

  Given the SAS data sets:

  

  The following SAS DATA step is submitted:

  

  What data values are stored in data set WORK.COMBINE?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 100:

  This question will ask you to provide a segment of missing code.

  Given the following program and data:

  

  What is the WHERE statement that successfully completes the PROC PRINT and selects the observation from Barb?

  A. Where Birthday=and"Want";

  B. Where Birthday=and`Want' d;

  C. Birthday=andWant;

  D. Birthday=and"Want" d;

  Correct Answer: A