SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 121:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  NUM COUNTRY NUM CITY

  ______________ ____________________________ ______ 1 CANADA 3 BERLIN

  2 FRANCE 5 TOKYO

  3 GERMANY 4 BELGIUM

  5 JAPAN

  The following SAS program is submitted:

  proc sql;

  select country

  from one where not exists

  (select * from two where one.num = two.num);

  quit;

  Which one of the following reports is generated?

  A. COUNTRY

  GERMANY

  JAPAN

  B. COUNTRY

  FRANCE

  BELGIUM

  C. COUNTRY

  CANADA

  FRANCE

  BELGIUM

  D. COUNTRY

  CANADA

  FRANCE

  GERMANY

  Correct Answer: C

• Question 122:

  Which one of the following statements is true?

  A. The WHERE statement can be executed conditionally as part of an IF statement.

  B. The WHERE statement selects observations before they are brought into the PDV.

  C. The subsetting IF statement works on observations before they are read into the PDV.

  D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

  Correct Answer: B

• Question 123:

  Which one of the following programs contains a syntax error?

  A. proc sql; select product.*, cost.unitcost, sales.quantity from product p, cost c, sales s where p.item = c.item and

  B. item = s.item; quit;

  C. proc sql; select product.*, cost.unitcost, sales.quantity from product, cost, sales where product.item = cost.item and product.item = sales.item; quit;

  D. proc sql; select p.*, c.unitcost, s.quantity from product as p, cost as c, sales as s where p.item = c.item and

  E. item = s.item; quit;

  F. proc sql; select p.*, c.unitcost, s.quantity from product, cost, sales where product.item = cost.item and product.item = sales.item; quit;

  Correct Answer: D

• Question 124:

  The following SAS code is submitted:

  %macro houses(dsn = houses,sub = RANCH);

  data anddsn;

  set sasuser.houses;

  if style = "andsub";

  run;

  %mend;

  %houses(sub = SPLIT)

  %houses(dsn = ranch)

  %houses(sub = TWOSTORY)

  Which one of the following is the value of the automatic macro variable SYSLAST?

  A. work.ranch

  B. work.houses

  C. WORK.RANCH

  D. WORK.HOUSES

  Correct Answer: D

• Question 125:

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

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

  The following SAS program is submitted:

  data one;

  do i = 1 to 10;

  ptobs = ceil(ranuni(0) * totobs);

  set temp point = ptobs

  nobs = totobs;

  output;

  end;

  stop;

  run;

  The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

  A. any integer between 1 and 10

  B. any real number between 0 and 1

  C. any integer between 1 and 2,500,000

  D. any real number between 1 and 2,500,000

  Correct Answer: C

• Question 128:

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

  Which one of the following options controls the pagesize of a SAS data set?

  A. SIZE=

  B. BUFNO=

  C. BUFSIZE=

  D. PAGESIZE=

  Correct Answer: C

• Question 130:

  Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

  A. RENAME statement only

  B. CHANGE statement only

  C. MODIFY and RENAME statements

  D. MODIFY and CHANGE statements

  Correct Answer: B