SASInstitute SAS Institute Systems Certification A00-202 Questions & Answers

• Question 41:

  Which one of the following is an advantage of creating and using a SAS DATA step view?

  A. It can store an index.

  B. It always accesses the most current data.

  C. It works quickly through multiple passes of the data.

  D. It is useful when the underlying data file structure changes.

  Correct Answer: B

• Question 42:

  Given the following SAS program:

  proc sql;

  select product, type, sum(sales) as revenue

  from one

  group by product, type;

  quit;

  Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

  A. order by 1, 3

  B. order by 1, 3 desc

  C. orderby product, revenue desc

  D. order by product, desc revenue

  Correct Answer: B

• Question 43:

  The following SAS program is submitted: %let name = Patel's Restaurant;

  Which one of the following statements avoids problems associated with the unbalanced quotation mark?

  A. %let name = Patel%'s Restaurant;

  B. %let name = %str(Patel's Restaurant);

  C. %let name = Patel%str(')s Restaurant;

  D. %let name = %str(Patel%'s Restaurant);

  Correct Answer: D

• Question 44:

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

  The following SAS program is submitted:

  %macro execute;

  proc print data = sasuser.houses;

  run;

  %end;

  %mend;

  Which of the following completes the above program so that it executes on Tuesday?

  A. %if andsysday = Tuesday %then %do;

  B. %if andsysday = 'Tuesday' %then %do;

  C. %if "andsysday" = Tuesday %then %do;

  D. %if 'andsysday' = 'Tuesday' %then %do;

  Correct Answer: A

• Question 46:

  The following SAS program is submitted:

  data temp;

  array points{2,3}_temporary_;

  run;

  Which one of the following is the maximum number of elements that are stored?

  A. 2

  B. 3

  C. 5

  D. 6

  Correct Answer: D

• Question 47:

  Which one of the following options displays the value of a macro variable in the SAS log?

  A. MACRO

  B. SOURCE

  C. SOURCE2

  D. SYMBOLGEN

  Correct Answer: D

• Question 48:

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

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

  The following SAS program is submitted:

  %macro test(var);

  proc print data = sasuser.class;

  where age > andvar;

  run;

  %mend;

  Which type of parameter is the macro variable VAR?

  A. default

  B. keyword

  C. positional

  D. command

  Correct Answer: C