SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 151:

  When is it appropriate to create indexes on a SAS data set for efficient processing?

  A. if small subsets of data are often retrieved

  B. if the key variable has very few unique values

  C. if the data are often used for BY group processing

  D. if the SAS data set file page count is less than three pages

  Correct Answer: A

• Question 152:

  The following SAS program is submitted:

  %macro loop;

  data one;

  %do I=1 %to 3;

  varandI=andI;%

  end

  run;

  %mend;

  %loop

  After this program executes; the following is written to the SAS log:

  (LOOP): Beginning execution

  (LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is (LOOP): %DO loop index variable l is now 2; loop will iterate again

  (LOOP): %DO loop index variable l is no 3; loop will iterate again

  (LOOP): %DO loop index variable l is no 4; loop will iterate again

  (LOOP): Ending execution

  Which SAS system option displays the notes in the SAS log?

  A. SYMBOLGEN

  B. MLOGIC

  C. MACRO

  D. MPRINT

  Correct Answer: B

• Question 153:

  The following SAS program is submitted:

  data temp;

  set sasuser.history(kep=date);

  format date qtr

  if first.date then total=0;

  total+1;

  if last.date;

  run;

  proc print data=temp;

  run

  SASUSER.HISTORY is sorted by the SAS date variable DATE.

  The following output is required: Date Total 1 13 3 15 4 25 Which By statement completes the data step and successfully generates the required output?

  A. by groupformat date;

  B. by formateed date;

  C. by notsorted date;

  D. by date qtr

  Correct Answer: A

• Question 154:

  Given the following SAS data set SASUSER.HIGHWAY:

  SASUSER.HIGHWAY

  STEERING SEATBELT SPEED STATUS COUNT

  absent no 0-29 serious 31

  absent no 0-29 not 1419

  absent no 30-49 serious 191

  absent no 30-49 not 2004

  absent no 50+ serious 216

  The following SAS program is submitted:

  %macro highway;

  proc sql noprint;

  select count(distinct status)

  into :numgrp

  from sasuser.highway;

  %let numgrp = andnumgrp;

  select distinct status

  into :group1-:groupandnumgrp

  from sasuser.highway;

  quit;

  %do i = 1 %to andnumgrp;

  proc print data = sasuser.highway;

  where status = "andandgroupandi" ;

  run;

  %end;

  %mend;

  %highway

  How many reports are produced by the above program?

  A. 0

  B. 1

  C. 2

  D. 5

  Correct Answer: C

• Question 155:

  What is generated as a result of submitting the RANUNI function with a seed of 123?

  A. A missing value because 123 is an invalid argument for the RANUNI function

  B. A different sequence of random numbers with each program execution

  C. A random number between 0 and 123

  D. A consistent sequence of random numbers with each program execution

  Correct Answer: D

• Question 156:

  The following SAS program is submitted:

  %let a=cat;

  %macro animal(a=frog);

  %let a=bird;

  %mend;

  %animal(a=pig)

  %put a is anda;

  What is written to the SAS log?

  A. a is pig

  B. a set cat

  C. a is frog

  D. a is bird

  Correct Answer: B

• Question 157:

  Given the following scenario:

  The SAS libraries LIBRARY and MYLIB are successfully defined in your current SAS session.

  There is a SAS Data Set named WORK.GENDERS with a column called MF containing single character values.

  The SAS program on the left is submitted and the desired output is shown in the right.

  

  Which statement is true?

  A. The statement OPTIONS FMTSEARCH = (Mylib Library); is required before the PRINT procedure to attain the resulting output

  B. The statement OPTIONS FMSEARCH = (Library Mylib); is required before the PRINT procedure to attain the resulting output

  C. No OPTIONS FMSEARCH ( ) statement is needed to attain resulting output

  D. The statement OPTIONS FMSEARCH = (Mylib); is required before the print procedure to attain the resulting output

  Correct Answer: D

• Question 158:

  The following SAS program is submitted:

  

  How will the variable be listed?

  A. Height Weight Name Age

  B. Weight Height

  C. Weight Height Name Age

  D. Name Age Weight Height

  Correct Answer: D

• Question 159:

  Given the SAS dataset ONE ONE SALARY

  The following SAS program is submitted Proc sql;

  Select * from one

  ;

  quit;

  The following output is desired:

  SALARY

  Which WHERE expression completes the program and generates the desired output?

  A. Where salary is not

  B. Where salary ne null

  C. Where salary is not missing

  D. Where salary ne missing

  Correct Answer: C

• Question 160:

  The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

  proc sort data=WORK.CHECK;

  by Code;

  run;

  What describes the result of submitting SAS program?

  A. The index on Code is updates

  B. The sort does not execute

  C. The index on Code is deleted

  D. The index on the Code unaffected

  Correct Answer: B