SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 81:

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

  The following SAS program is submitted:

  date view=sauser.ranch;

  describe;

  run;

  What is the result?

  A. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window

  B. The program retrieves the SAS source code that creates the view and places it in the output window

  C. The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log

  D. the program retrieves the SAS source code that creates the view and places it in the SAS log

  Correct Answer: D

• Question 83:

  Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

  A. MODIFY

  B. FORMAT

  C. CONTENTS

  D. DATASETS

  Correct Answer: D

• Question 84:

  Given the following SAS data set ONE:

  ONE

  COUNTRY CITY VISIT

  USA BOSTON 10

  UK LONDON 5

  USA DALLAS 10

  UK MARLOW 10

  USA BOSTON 20

  UK LONDON 15

  USA DALLAS 10

  The following SAS program is submitted:

  proc sql;

  select country, city, sum(visit) as TOTAL

  from one

  group by country, city

  order by country, total desc;

  quit;

  Which one of the following reports is generated?

  A. COUNTRY CITY TOTAL UK MARLOW 10 UK LONDON 20 USA BOSTON 50 USA DALLAS 20

  B. COUNTRY CITY TOTAL UK LONDON 20 UK MARLOW 10 USA BOSTON 50 USA DALLAS 20

  C. COUNTRY CITY TOTAL USA BOSTON 50

  D. COUNTRY CITY TOTAL UK MARLOW 10 UK LONDON 20 USA DALLAS 20 USA BOSTON 50

  Correct Answer: B

• Question 85:

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

  The following SAS program is submitted: % let product = merchandise;

  And the following message is written to the SAS log: The value is "merchandise"

  Which macro statement wrote this message?

  A. % put the value is "andproduct.";

  B. % put the value is ""andproduct."";

  C. % put the value is "%quote(andproduct).";

  D. % put the value is ` " `andproduct. ` " ` ;

  Correct Answer: A

• Question 87:

  The following SAS program is submitted:

  Data sasuser.history;

  Set sasuser.history(keep=state x y

  Rename = (state=ST));

  Total=sum(x, y);

  Run;

  The SAS data set SASUSER.HISTORY has an index on the variable STATE.

  Which describes the result of submitting the SAS program?

  A. The index on STATE is deleted and an index on ST is created

  B. The index on STATE is recreated as an index on ST

  C. The index on STATE is deleted

  D. The index on STATE is updated as an index on ST

  Correct Answer: C

• Question 88:

  At the start of a new SAS session; the following program is submitted:

  %macro one;

  data _null_;

  call symput('proc','measn);

  run;

  proc andproc data=sashelp.class;

  run;

  %mend;

  %one()

  What is the result?

  A. The marco variable PRCO is stored in the SAS catalog WORK.SASMACR

  B. The program fails to execute because PROC is a reserved word

  C. The macro variable PROC is stored in the local symbol table

  D. The macro variable PROC is stored in the global symbol table

  Correct Answer: D

• Question 89:

  The following SAS program is submitted:

  proc sort data = sales tagsort;

  by month year;

  run;

  Which of the following resource(s) is the TAGSORT option reducing?

  A. I/O usage only

  B. CPU usage only

  C. I/O and CPU usage

  D. temporary disk usage

  Correct Answer: D

• Question 90:

  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;

  What are the names of all of the columns created by the TRANSPOSE procedure?

  A. new, X,Y and _COL1_

  B. new, X and COL1 only

  C. new, Y and COL1 only

  D. new, X and Y only

  Correct Answer: B