SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 81:

  The SAS data set WORK STAFF has three variables:

  Name is character with a length of 8 DOB is numeric with a length of 8 Start_Date is numeric with a length of 8

  The following SAS program is submitted:

  

  What is the length of the Name variable in the data set WORK STAFF_UPDATE?

  A. 10
  B. 15
  C. 20
  D. 8
  A. 10

• Question 82:

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

  capacity airplanetype staff 150 Large 10

  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'; staff = 5; end; run;
  D. data work.test; capacity = 150; if 100 le capacity le 200 then; airplanetype = 'Small'; staff = 5; else; 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 83:

  The following SAS program is submitted:

  proc sort data = work.employee;

  by descending fname;

  proc sort data = work.salary;

  by descending fname;

  data work.empdata;

  merge work.employee

  work.salary;

  by fname;

  run;

  Why does the program rail to execute?

  A. The SORT procedures contain invalid syntax.
  B. The merged data sets are not permanent SAS data sets.
  C. The RUN statement was omitted alter each or the SORT procedures.
  D. The data sets were not merged in the order by which they were sorted.
  D. The data sets were not merged in the order by which they were sorted.

• Question 84:

  A raw data file is listed below:

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

  John McCloskey 35 71

  June Rosesette 10 43

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

  Given the raw data file `DEPENDENTS.TXT':

  

  The following SAS program is submitted:

  

  What will be the value of _ERROR_ in the Program Data Vector for each iteration of the DATA step?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

• Question 86:

  Consider the data step:

  

  Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

  A. if Age not in(15,16) then Group=1; else Group=2;
  B. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
  C. where Age not between 15 and 16 then Group=1; else Group=2;
  D. both A or C will work.
  A. if Age not in(15,16) then Group=1; else Group=2;

• Question 87:

  The following SAS program is submitted:

  

  The program fails execution due to syntax errors. What is the cause of the syntax error?

  A. The variable MONTHSALES does not exist.
  B. An array cannot be referenced on a KEEP data set option.
  C. The KEEP= data set option should be (KEEP = MONTHSALES).
  D. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.
  B. An array cannot be referenced on a KEEP data set option.

• Question 88:

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

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

  chair,,table

  chair,couch,table

  The following SAS program is submitted:

  data stock;

  infile 'furniture' dsd;

  input item1 $ item2 $ item3 $;

  run;

  Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

  A. table
  B. ,table
  C. . (missing numeric value)
  D. ' ' (missing character value)
  D. ' ' (missing character value)

• Question 89:

  Given the raw data file YEARAMT:

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

  1901 2

  1905 1

  1910 6

  1925 .

  1941 1

  The following SAS program is submitted:

  data coins;

  infile `yearamt';

  input year quantity;

  run;

  Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?

  A. totquantity + quantity;
  B. totquantity = sum(totquantity + quantity);
  C. retain totquantity; totquantity = totquantity + quantity;
  D. retain totquantity0; totquantity = totquantity + quantity;
  A. totquantity + quantity;

• Question 90:

  Given the SAS data set AGES: AGES AGE

  The variable AGE contains character values. The following SAS program is submitted:

  data subset;

  set ages;

  where age> 12;

  run;

  How many observations are written out to the data set SUBSET?

  B. 1
  C. 2
  D. 3
  A