SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 101:

  The following SAS program is submitted:

  proc report data = sasuser.houses nowd headline headskip; column style price;

  where price < 100000;

  title;

  run;

  Click the Exhibit button to view the output from the REPORT procedure.

  

  Assuming that the PRICE variable is numeric, which one of the following completes the program and produces the output displayed in the exhibit?

  A. define style / group `Style'; define price / mean `Price' format = dollar9.;
  B. define style / display `Style'; define price / across `Price' format = dollar9.;
  C. define style / display `Style'; define price / sum `Price' format = dollar9.;
  D. define style / order `Style'; define price / mean `Price' format = dollar9.;
  C. define style / display `Style'; define price / sum `Price' format = dollar9.;

• Question 102:

  A raw data file is listed below:

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

  squash 1.10 apples 2.25 juice 1.69

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

  data groceries; infile `file-specification'; input item $ cost; run;

  Which one of the following completes the program and produces a grand total for all COST values?

  A. grandtot = sum cost;
  B. grandtot = sum(grandtot,cost);
  C. retain grandtot 0; grandtot = sum(grandtot,cost);
  D. grandtot = sum(grandtot,cost); output grandtot;
  A. grandtot = sum cost;

• Question 103:

  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; 1100 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 104:

  Click the Exhibit button to view a listing of the SASUSER.HOUSES data set.

  style price

  CONDO $79,700

  RANCH $68,575

  SPLIT $77,983

  TWOSTORY $62,550

  The following SAS program is submitted:

  proc report data = sasuser.houses nowd headline;

  column style price;

  where price It 100000;

  define price / mean width = 9;

  title;

  run;

  The following output is created by the REPORT procedure:

  

  Which one of the following DEFINE statements completes the above program and produces the above output?

  A. define style / order width = 9;
  B. define style / group width = 9;
  C. define style / across width = 9;
  D. define style / display width = 9;
  B. define style / group width = 9;

• Question 105:

  The following SAS program is submitted:

  data test;

  set sasuser.employees;

  if 2 le years_service le 10 then

  amount = 1000;

  else if years service gt 10 then

  amount = 2000;

  else

  amount = 0;

  amount_per_year = years_service / amount;

  run;

  Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?

  B. 1000
  C. 2000
  D. (missing numeric value)
  C. 2000

• Question 106:

  The following SAS program is submitted:

  data work.total;

  set work.salary(keep = department wagerate);

  by department;

  if first.department then payroll = 0;

  payroll + wagerate;

  if last.department;

  run;

  The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.

  Which one of the following is true regarding the program above?

  A. The BY statement in the DATA step causes a syntax error.
  B. FIRST.DEPARTMENT and LAST DEPARTMENT are variables in the WORK.TOTAL data set.
  C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
  D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.
  C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

• Question 107:

  The following SAS program is submitted:

  data work.test;

  First = `lpswich, England';

  City_Country = substr(First,1,7)!!', `!!`England'; run;

  Which one of the following is the length of the variable CITY_COUNTRY in the output data set?

  A. 6
  B. 7
  C. 17
  D. 25
  D. 25

• Question 108:

  The following SAS program is submitted:

  data work.test;

  Author = `Christie, Agatha';

  First = substr(scan(author,2,' ,`),1, 1);

  run;

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

  A. A
  B. C
  C. Agatha
  D. ``(missing character value)
  A. A

• Question 109:

  The following SAS program is submitted and reads 100 records from a raw data file:

  data work.total;

  infile `file-specification' end = eof;

  input name $ salary;

  totsal + salary;

  run;

  Which one of the following IF statements writes the last observation to the output data set?

  A. if end = 0;
  B. if eof = 0;
  C. if end = 1;
  D. if eof = 1;
  D. if eof = 1;

• Question 110:

  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;

  Which one of the following statements explains why the program failed execution?

  The SORT procedures contain invalid syntax.

  The merged data sets are not permanent SAS data sets. The data sets were not merged in the order by which they were sorted. The RUN statements were omitted after each of the SORT procedures.