SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 111:

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

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

  Ruth 39 11

  Jose 32 22

  Sue 30 33

  John 40 44

  The following SAS program is submitted:

  data test;

  infile `employee';

  input employee_name $ 1-4;

  it employee_name = `Ruth' then input idnum 10-11;

  else input age 7-8;

  run;

  Which one of the following values does the variable IDNUM contain when the name of the employee is "Ruth"?

  A. 11
  B. 22
  C. 32
  D. (missing numeric value)
  B. 22

• Question 112:

  The following SAS SORT procedure step generates an output data set:

  proc sort data = sasuser.houses out = report;

  by style;

  run;

  In which library is the output data set stored?

  A. WORK
  B. REPORT
  C. HOUSES
  D. SASUSER
  A. WORK

• Question 113:

  The following SAS program is submitted:

  proc datasets lib = sasuser; contents data = class varnum; quit;

  Which one of the following is the purpose of the VARNUM option?

  A. to print a list of variable names
  B. to print the total number of variables
  C. to print a list of the variables in alphabetic order
  D. to print a list of the variables in the order they were created
  D. to print a list of the variables in the order they were created

• Question 114:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 7;

  if amount = 5 then word = `CAT';

  else if amount = 7 then word = `DOG';

  else word = `NONE!!!';

  amount = 5;

  run;

  Which one of the following represents the values of the AMOUNT and WORD variables?

  A. amount word 5 DOG
  B. amount word 5 CAT
  C. amount word 7 DOG
  D. amount word 7 " " (missing character value)
  A. amount word 5 DOG

• Question 115:

  The following SAS program is submitted:

  data work.totalsales;

  set work.monthlysales(keep = year product sales);

  retain monthsales {12};

  array monthsales {12};

  do i = 1 to 12;

  monthsales{i} = sales;

  end;

  cnt + 1;

  monthsales{cnt} = sales;

  run;

  The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

  Which one of the following is the result of the above program?

  A. The program fails execution due to data errors.
  B. The program fails execution due to syntax errors.
  C. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.
  D. The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations.
  B. The program fails execution due to syntax errors.

• Question 116:

  The SAS data set EMPLOYEE_INFO is listed below:

  IDNUMBER Expenses

  2542 100.00

  3612 133.15

  2198 234.34

  2198 111.12

  The following SAS program is submitted:

  proc sort data = employee_info;

  run;

  Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

  A. by descending IDNumber Expenses;
  B. by (IDNumber Expenses) descending;
  C. by IDNumber descending Expenses descending;
  D. by descending IDNumber descending Expenses;
  D. by descending IDNumber descending Expenses;

• Question 117:

  The following SAS program is submitted:

  data work.report; set work.sales_info; if qtr(sales_date) ge 3; run;

  The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.

  How many of the original twelve observations in WORKSALES_INFO are written to the WORKREPORT data set?

  A. 2
  B. 3
  C. 6
  D. 9
  C. 6

• Question 118:

  The contents of two SAS data sets named EMPLOYEE and SALARY are listed below.

  EMPLOYEE SALARY

  name age name salary

  Bruce 30 Bruce 40000

  Dan 35 Bruce 35000

  Dan 37000

  Dan

  The following SAS program is submitted:

  data work.empsalary

  merge work.employee (in = inemp)

  work.salary (in = insal);

  by name;

  if inemp and insal;

  run;

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

  A. 2
  B. 4
  C. 5
  D. 6
  B. 4

• Question 119:

  The following SAS program is submitted:

  data work.retail; cost = `20000'; total = .10*cost; run;

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

  A. 2000
  B. `2000'
  C. (missing numeric value)
  D. ` `(missing character value)
  A. 2000

• Question 120:

  The following SAS program is submitted:

  data work.flights;

  destination = `CPH';

  select(destination);

  when('LHR') city = `London';

  when('CPH') city = `Copenhagen';

  otherwise;

  end;

  run;

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

  A. London
  B. Copenh
  C. Copenhagen
  D. ` `(missing character value)
  B. Copenh