SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 1:

  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
  C. 8

• Question 2:

  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
  A. if small subsets of data are often retrieved

• Question 3:

  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
  C. WARM

• Question 4:

  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;
  C. data new(bufsize = 2000 bufno = 3); set temp; run;

• Question 5:

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

• Question 6:

  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
  A. the APPEND procedure

• Question 7:

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

  A. NODUP
  B. UNIQUE
  C. DISTINCT
  D. NODUPKEY
  A. NODUP

• Question 8:

  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.
  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

• Question 9:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first
  B. andfirst
  C. yourname
  D. andyourname
  C. yourname

• Question 10:

  In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

  A. data three; set one; set two key = char1; run;
  B. data three; set one; if char1 in ('new york' 'los angeles'); run;
  C. data three; set one; where char1 in ('new york' 'los angeles'); run;
  D. proc sql; create table three as select * from one, two where one.char1 > two.char1; quit;
  A. data three; set one; set two key = char1; run;