SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 91:

  The following SAS program is submitted:

  proc contents data = testdata.one;

  run;

  Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

  A. proc sql; show testdata.one; quit;
  B. proc sql; describe testdata.one; quit;
  C. proc sql; show table testdata.one; quit;
  D. proc sql; describe table testdata.one; quit;
  D. proc sql; describe table testdata.one; quit;

• Question 92:

  Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

  A. proc datasets lib = sasuser.all; quit;
  B. proc datasets lib = sasuser._all_; quit;
  C. proc datasets lib = sasuser; contents data = all; quit;
  D. proc datasets lib = sasuser; contents data = _all_; quit;
  D. proc datasets lib = sasuser; contents data = _all_; quit;

• Question 93:

  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.
  B. It always accesses the most current data.

• Question 94:

  Which one of the following statements about compressed SAS data sets is always true?

  A. Each observation is treated as a single string of bytes.
  B. Each observation occupies the same number of bytes.
  C. An updated observation is stored in its original location.
  D. New observations are added to the end of the SAS data set.
  A. Each observation is treated as a single string of bytes.

• Question 95:

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

• Question 96:

  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';
  D. data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Small'; 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';

• Question 97:

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

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

  A. SIZE=
  B. BUFNO=
  C. BUFSIZE=
  D. PAGESIZE=
  C. BUFSIZE=

• Question 99:

  Which one of the following is true regarding the KEEP statement?

  A. The KEEP statement is available in both the DATA and the PROC steps.
  B. The KEEP statement selects the variables read from the input data set(s).
  C. The KEEP statement applies to all data sets created within the same DATA step.
  D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.
  C. The KEEP statement applies to all data sets created within the same DATA step.

• Question 100:

  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
  C. any integer between 1 and 2,500,000