SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 21:

  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

• Question 22:

  Consider the following SAS log:

  229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;

  230 set sasuser.houses;

  231 if style = 'RANCH' then output sasuser.ranch;

  232 else if style = 'CONDO' then output sasuser.condo;

  233 run;

  NOTE: DATA STEP view saved on file SASUSER.RANCH.

  NOTE: A stored DATA STEP view cannot run under a different operating system.

  235 proc print data = sasuser.condo;

  ERROR: File SASUSER.CONDO.DATA does not exist.

  236 run;

  NOTE: The SAS System stopped processing this step because of errors.

  Which one of the following explains why the PRINT procedure fails?

  A. SASUSER.CONDO is a stored DATA step program.

  B. A SAS data file and SAS data view cannot be created in the same DATA step.

  C. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.

  D. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.

  Correct Answer: D

• Question 23:

  Given the following partial SAS log:

  NOTE: SQL table SASHELP.CLASS was created line

  Create table SASHELP.CLASS(bufsize=4096)

  (

  Name char(8);

  Gender Char(1);

  Age num;

  Height num;

  Weight num

  );

  Which SQL procedure statement generated this output?

  A. DESCRIBE TABLE

  B. LIST TABLE

  C. VALIDATE TABLE

  D. CREATE TABLE

  Correct Answer: A

• Question 24:

  Following SAS program is submitted:

  data temp();

  infile 'rawdata';

  input x $ y z;

  run;

  RAWDATA is a file reference to an external file that is ordered by the variable X.

  Which option specifies how the data in the SAS data set TEMP will be sorted?

  A. ORDEREDBY=X

  B. GROUPBY=X

  C. SORTEDBY=X

  D. SORTSYNC=X

  Correct Answer: C

• Question 25:

  The following SAS program is submitted: %micro cols1;

  name age;

  %mend;

  %macro cols2;

  height weight

  %mend

  proc print data=sashelp.class;

  Run

  Which VAR statement successfully completes the program and produces a report?

  A. var heigh %cols1;

  B. var %cols1 %cols2 height;

  C. var %cols1 height;

  D. var %cols2 %cols1;

  Correct Answer: A

• Question 26:

  The following SAS program is submitted:

  

  The purpose of FILEVAR = option on the INFILE statement is to name the variable next, whose value:

  A. Points to a new input file

  B. Points to an aggregate storage location

  C. Is output to the SAS data set WORK.NEW

  D. Is an input SAS data set reference

  Correct Answer: D

  Reference:

  http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a00014 6932.htm (see FILEVAR=variable)

• Question 27:

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

  The following SAS program is submitted:

  %macro one (input);

  %two;

  %put the value is anddate;

  %mend;

  %macro two;

  data _null_;

  call symput('date','12SEP2008');

  run;

  %mend;

  %let date=31DEC2006;

  %one(anddate)

  What is the result when the %PUT statement executes?

  A. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro

  B. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro

  C. A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table

  D. A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table

  Correct Answer: C

• Question 29:

  Given the data sets shown on the left, the SAS program shown on the right is submitted.

  

  What will be output by the program?

  A. ERROR: Subquery evaluated to more than one row

  B. Average of Employment 6

  C. Average of Employment 5

  D. Average of employment 7

  Correct Answer: C

• Question 30:

  A data set stored on a network drive has the following characteristics:

  14 Million observations 400 numeric variables 0 character variables of length 20 Binary compression

  A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this DATA Step?

  A. A KEEP= data set option used on the SET Statement

  B. A KEEP Statement used within the DATA Step

  C. A KEEP= data set option used on the DATA Statement

  D. A DROP= data set option used on the DATA Statement

  Correct Answer: D