SASInstitute SAS Institute Systems Certification A00-212 Questions & Answers

• Question 41:

  The SAS data set ONE contains fifty million observations and contains the variable

  PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

  A. data two; Set one; Where totrev>1000; Totrev=sum(price*quantity); Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;

  B. data two; Set one; totrev=sum(price*quantity); where totrev>1000; totcost=sum(fixed,variable); profit=sum(totrev,-totcost); run;

  C. data two; Set one; Totrev=sum(price*quantity); If totrev>1000; Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;

  D. data two; Set one; Totrev = sum(price*quantity); Totcost= sum(fixed,variable); If totrev>1000;

  Profit=sum(totrev,-totcost);

  Run;

  Correct Answer: C

• Question 42:

  The following SAS program is submitted:

  options yearcutoff = 1950;

  %macro y2kopt(date);

  %if anddate >= 14610 %then %do;

  options yearcutoff = 2000;

  %end;

  %else %do;

  options yearcutoff = 1900; %end;

  %mend;

  data _null_ ;

  date = "01jan2000"d;

  call symput("date",left(date));

  run;

  %y2kopt(anddate)

  The SAS date for January 1, 2000 is 14610 and the SAS system option for

  YEARCUTOFF is set to 1920 prior to submitting the above program.

  Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

  A. 1900

  B. 1920

  C. 1950

  D. 2000

  Correct Answer: D

• Question 43:

  Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS

  M 28 200 .

  M 25 100 10

  F 18 100 50

  F 25 200 10

  The following SAS program is submitted:

  proc sql;

  create table two as

  select category, salary + bonus as EARNINGS

  from one; quit;

  Which one of the following represents the data values stored in the data set TWO?

  A. CATEGORY EARNINGS M 200 M 110 F 150 F 210

  B. CATEGORY EARNINGS

  M .

  M 110

  F 150

  F 210

  C. CATEGORY SALARY BONUS EARNINGS M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210

  D. CATEGORY SALARY BONUS EARNINGS M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210

  Correct Answer: B

• Question 44:

  Given the SAS data set ONE: ONE

  NUM VAR

  1 A

  2 B

  3 C

  Which SQL procedure program deletes the data set ONE?

  A. proc sql; Drop table one; Quit;

  B. proc sql; Remove table one; Quit;

  C. proc sql; Delete table one; Quit;

  D. proc sql; Delete from one; Quit;

  Correct Answer: A

• Question 45:

  The following SAS program is submitted:

  

  What is written to the SAS log?

  A. Mv is bicycle

  B. Mv is shoes

  C. Mv is tents

  D. Mv is clothes

  Correct Answer: B

• Question 46:

  The following SAS program is submitted:

  ;

  %let development = ontime;

  proc print data = sasuser.highway;

  title "For anddept";

  title2 "This project was completed anddevelopment";

  run;

  Which one of the following statements completes the above and resolves title1 to "For

  researchanddevelopment"?

  A. %let dept = %str(researchanddevelopment);

  B. %let dept = %str(research%anddevelopment);

  C. %let dept = %nrstr(researchanddevelopment);

  D. %let dept = %nrstr(research%anddevelopment);

  Correct Answer: C

• Question 47:

  The following SAS program is submitted:

  %macro test(var);

  %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;

  %let type = %index(andjobs,andvar);

  %mend;

  %test(SMITH)

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

  A. 0

  B. 3

  C. 6

  D. null

  Correct Answer: C

• Question 48:

  Given the following SAS statement: %let idcode = Prod567;

  Which one of the following statements stores the value 567 in the macro variable CODENUM?

  A. %let codenum = substr(andidcode,length(andidcode)-2);

  B. %let codenum = substr(andidcode,length(andidcode)-3);

  C. %let codenum = %substr(andidcode,%length(andidcode)-2);

  D. %let codenum = %substr(andidcode,%length(andidcode)-3);

  Correct Answer: C

• Question 49:

  The following SAS program is submitted:

  

  What is written to the SAS log?

  A. andName2

  B. MATH3

  C. WARNING: Apparent symbolic reference ROOT2 not resolved

  D. MATH1

  Correct Answer: B

• Question 50:

  This question will ask you to provide a segment of missing code. Given the SAS data set SASUSER.HIGHWAY:

  

  The following SAS program is submitted:

  

  Which SQL clause stores the text 0-29, 30-49, 60+ in the macro variable GROUPS?

  A. into : GROUPS separated by ` , '

  B. : into GROUPS separated = ` , '

  C. Into : GROUPS delimited by ` , '

  D. : into GROUPS delimited by ` , '

  Correct Answer: A

  Reference: http://analytics.ncsu.edu/sesug/2006/CC01_06.PDF (page 2, creating the macro variable)