SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 81:

  The SAS data set WORK.AWARDS is listed below:

  The following SAS program is submitted:

  proc sort data = work.awards;

  by descending fname points;

  run;

  Which one of the following represents how the observations are sorted?

  

  A. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1
  B. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1
  C. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1
  D. Wang 1D.Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2
  D. Wang 1D.Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2

• Question 82:

  The following SAS program is submitted:

  data work.sets;

  do until (prod gt 6);

  prod + 1;

  end;

  run;

  Which one of the following is the value of the variable PROD in the output data set?

  A. 5
  B. 6
  C. 7
  D. 6
  C. 7

• Question 83:

  The contents of the raw data file CALENDAR are listed below:

  ----|----10----|----20----|----30

  01012000

  The following SAS program is submitted:

  data test;

  infile `calendar';

  input@1 date mmddyy10.;

  if date = `01012000'd then event = `January 1st;

  run;

  Which one of the following is the value of the EVENT variable?

  A. 01012000
  B. January 1st
  C. .(missing numeric value)
  D. The value can not be determined as the program fails to execute due to errors.
  D. The value can not be determined as the program fails to execute due to errors.

• Question 84:

  The following SAS program is submitted:

  data work.test;

  array agents{4}$ 12 sales1 - sales4

  run;

  Which one of the following represents the variables that are contained in the output data set?

  A. SALES1, SALES2, SALES3, SALES4
  B. AGENTS1, AGENTS2, AGENTS3, AGENTS4
  C. None, the DATA step fails because the ARRAY statement can reference only numeric data.
  D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.
  A. SALES1, SALES2, SALES3, SALES4

• Question 85:

  The following SAS DATA step is submitted: data sasdata.atlanta

  sasdata.boston

  work.portland work.phoenix;

  set company.prdsales;

  if region = `NE' then output boston;

  if region = `SE' then output atlanta;

  if region = `SW' then output phoenix;

  if region = `NW' then output portland;

  run;

  Which one of the following is true regarding the output data sets?

  A. No library references are required.
  B. The data sets listed on all the IF statements require a library reference.
  C. The data sets listed in the last two IF statements require a library reference.
  D. The data sets listed in the first two IF statements require a library reference.
  D. The data sets listed in the first two IF statements require a library reference.

• Question 86:

  The contents of the raw data file SIZE are listed below:

  ----I----10---I----20---I----30 72 95

  The following SAS program is submitted:

  data test;

  infile `size';

  input@1 height 2. @4 weight 2;

  run;

  Which one of the following is the value of the variable WEIGHT in the output data set?

  A. 2
  B. 72
  C. 95
  D. . (missing numeric value)
  A. 2

• Question 87:

  The SAS data set named WORK.TEST is listed below:

  Which one of the following SAS programs created this data set?

  A. data work.test; capacity= 150; if 100 le capacity le 200 then airplanetype = `Large' and staff = 10; else airplanetype = `Small' and staff = 5; run;
  B. data work.test capacity= 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff= 10; end; else do; airplanetype = `Small'; staff = 5; end; run;
  C. data work.test; capacity = 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff = 10; else do; airplanetype = `Small'; airplanetype = `Small'; staff = 5; end; run;
  D. data work.test;D.data work.test capacity = 150; if 100 le capacity le 200 then; airplanetype = `Small'; airplanetype = `Small'; staff = 5; else; airplanetype = `Large'; airplanetype = `Large'; staff= 10; run;
  B. data work.test capacity= 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff= 10; end; else do; airplanetype = `Small'; staff = 5; end; run;

• Question 88:

  The contents of the raw data file AMOUNT are listed below:

  ----I----10---I----20---I----30

  $1,234

  The following SAS program is submitted:

  data test;

  infile `amount;

  input @1 salary 6

  if _error_ then description = `Problems';

  else description = `No Problems';

  run;

  Which one of the following is the value of the DESCRIPTION variable?

  A. Problems
  B. No Problems
  C. `` (missing character value)
  D. The value can not be determined as the program fails to execute due to errors.
  A. Problems

• Question 89:

  A raw data file is listed below:

  ----I----1 0---I----20---I----30

  John McCloskey 35 71

  June Rosesette 1043

  Tineke Jones 9 37

  The following SAS program is submitted using the raw data file as input:

  data work.homework;

  infile `file-specification';

  input name $ age height

  if age LE 10;

  run;

  How many observations will the WORK.HOMEWORK data set contain?

  B. 2
  C. 3
  D. No data set is created as the program fails to execute due to errors.
  C. 3

• Question 90:

  The following SAS program is submitted:

  data numrecords;

  infile `file-specification';

  input@1 patient $15.

  relative$ 16-26@;

  if relative = `children' then

  input diagnosis $15. @;

  else if relative = `parents' then

  input @28 doctor $15.

  clinic $ 44-53

  @54diagnosis $15. @;

  input age;

  run;

  How many raw data records are read during each iteration of the DATA step during execution?

  A. 1
  B. 2
  C. 3
  D. 4
  A. 1