SASInstitute SAS Institute Systems Certification A00-202 Questions & Answers

• Question 1:

  The following SAS program is submitted:

  data new (bufsize = 6144 bufno = 4);

  set old;

  run;

  Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

  A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.

  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

  C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.

  D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.

  Correct Answer: B

• Question 2:

  Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

  A. NODUP

  B. UNIQUE

  C. DISTINCT

  D. NODUPKEY

  Correct Answer: A

• Question 3:

  Which one of the following techniques concatenates data in SAS?

  A. the APPEND procedure

  B. the DATA step with a MERGE statement

  C. the DATA step with a COMBINE statement

  D. the INTERSECT operator in the SQL procedure

  Correct Answer: A

• Question 4:

  Given the following SAS data sets ONE and TWO:

  ONE TWO YEAR QTR BUDGET YEAR QTR SALES ------------------------------- -------------------------------- 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one, two;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES

  2001 4 400 300

  2002 1 700 600

  B. YEAR QTR BUDGET SALES

  2001 3 500 .

  2001 4 400 300

  2002 1 700 600

  C. YEAR QTR BUDGET SALES

  2001 3 500 300

  2001 4 400 300

  2002 1 700 600

  D. YEAR QTR BUDGET SALES

  2001 3 500 300

  2001 4 400 300

  2002 1 700 300

  2001 3 500 600

  2001 4 400 600

  2002 1 700 600

  Correct Answer: D

• Question 5:

  Which one of the following SAS programs uses the most amount of memory resources for output buffers?

  A. data new(bufsize = 1000 bufno = 5); set temp; run;

  B. data new(bufsize = 1000 bufno = 2); set temp; run;

  C. data new(bufsize = 2000 bufno = 3); set temp; run;

  D. data new(bufsize = 4000 bufno = 1); set temp; run;

  Correct Answer: C

• Question 6:

  The following SAS FORMAT procedure is submitted:

  proc format lib = sasuser;

  value tempc low < 0 = 'BELOW FREEZING'

  0 < 5 = 'COLD'

  5 < 10 = 'MILD'

  10 < 15 = 'WARM'

  15 high = 'HOT';

  run;

  How is the value 10 displayed when the format TEMPC is applied?

  A. 10

  B. MILD

  C. WARM

  D. BELOW FREEZING

  Correct Answer: C

• Question 7:

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

  The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ;

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

  A. 3

  B. 7

  C. 8

  D. 11

  Correct Answer: C

• Question 9:

  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. 5D.5

  Correct Answer: C

• Question 10:

  The SAS data set TEMP has the following distribution of values for variable A:

  A Frequency 1 500,000 2 500,000 6 7,000,000 8 3,000

  Which one of the following SAS programs requires the least CPU time to be processed?

  A. data new; set temp; if a = 8 then b = 'Small '; else if a in(1, 2) then b = 'Medium'; else if a = 6 then b = 'Large'; run;

  B. data new; set temp; if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small'; else if a = 6 then b = 'Large'; run;

  C. data new; set temp; if a = 6 then b = 'Large '; else if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small'; run;

  D. data new;D.data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Medium'; if a = 8 then b = 'Small'; run;

  Correct Answer: C