SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 11:

  Which one to the following SAS procedures displays the data portion of a SAS data set?

  A. PRINT
  B. FSLIST
  C. CONTENTS
  D. DATASETS
  A. PRINT

• Question 12:

  A SAS program is submitted and the following SAS log is produced:

  2 data gt100;

  3 set ia.airplanes

  4 if mpg gt 100 then output

  22 202

  ERROR: File WORK.IF.DATA does not exist.

  ERROR: File WORK.MPG.DATA does not exist.

  ERROR: File WORK.GT.DATA does not exist.

  ERROR: File WORK.THEN.DATA does not exist.

  ERROR: File WORK.OUTPUT DATA does not exist.

  ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (,;, END, KEY, KEYS, NOBS, OPEN, POINT,_DATA_,_LAST_, NULL_

  ERROR 202-322: The option or parameter is not recognized and will be ignored.

  5 run;

  The IA libref was previously assigned in this SAS session.

  Which one of the following corrects the errors in the LOG?

  A. Delete the word THEN on the IF statement.
  B. Add a semicolon at the end of the SET statement.
  C. Place quotes around the value on the IF statement.
  D. Add an END statement to conclude the IF statement.
  B. Add a semicolon at the end of the SET statement.

• Question 13:

  The following SAS program is submitted:

  data work.january;

  set work.allmonths (keep = product month num_sold cost); if month = `Jan' then output work.january

  sales = cost * num_sold;

  keep = product sales;

  run;

  Which variables does the WORK.JANUARY data set contain?

  A. PRODUCT and SALES only
  B. PRODUCT, MONTH, NUM_SOLD and COST only
  C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
  D. An incomplete output data set is created due to syntax errors.
  D. An incomplete output data set is created due to syntax errors.

• Question 14:

  The following SAS program is submitted:

  proc contents data = sasuser.airplanes; run;

  Which one of the following is produced as output?

  A. the data portion of every data set in the SASUSER library
  B. the data portion of the data set SASUSER.AIRPLANES only
  C. the descriptor portion of every data set in the SASUSER library
  D. the descriptor portion of the data set SASUSER AIRPLANES only
  D. the descriptor portion of the data set SASUSER AIRPLANES only

• Question 15:

  The following SAS program is submitted:

  data work.accounting;

  set work.dept1 work.dept2;

  run;

  A character variable named JOBCOE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.

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

  A. 5
  B. 7
  C. 8
  D. 12
  A. 5

• Question 16:

  The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".

  Which one of the following SAS programs temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?

  A. proc print data = sasuser.houses; label price = "Sale Price"; run;
  B. proc print data = sasuser.houses label; label price "Sale Price"; run;
  C. proc print data = sasuser.houses label; label price = "Sale Price"; run;
  D. proc print data = sasuser.houses label = "Sale Price"; run;
  C. proc print data = sasuser.houses label; label price = "Sale Price"; run;

• Question 17:

  In the following SAS program, the input data files are sorted by the NAMES variable:

  libname temp SAS-data-library';

  data temp.sales;

  merge temp.sales

  work.receipt;

  by names;

  run;

  Which one of the following results occurs when this program is submitted?

  A. The program executes successfully and a temporary SAS data set is created.
  B. The program executes successfully and a permanent SAS data set is created.
  C. The program fails execution because the same SAS data set is referenced for both read and write operations.
  D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
  B. The program executes successfully and a permanent SAS data set is created.

• Question 18:

  A raw data record is shown below:

  07Jan2002

  Which one of the following in formats would read this value and store it as a SAS date value?

  A. date9.
  B. dmonyy9.
  C. ddMMMyy9.
  D. ddmmmyyyy9.
  A. date9.

• Question 19:

  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 WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

  Which one of the following represents how many observations the WORK.TOTAL data set contains?

  A. 5
  B. 20
  C. 100
  D. 500
  A. 5

• Question 20:

  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;
  B. if eof = 0;