SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 211:

  The following SAS program is submitted:

  

  What is the initial value of the variable Total in the following program?

  B. Missing
  C. The value of the first observations Wagerate
  D. Cannot be determined from the information given
  B. Missing

• Question 212:

  Given the following raw data records:

  

  The following output data set is desired:

  

  Which SAS program correctly reads in the raw data?

  

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

• Question 213:

  Which step displays a listing of all the data sets in the WORK library?

  A. proc contents lib=WORK run;
  B. proc contents lib=WORK.all; run;
  C. proc contents data=WORK._all_; run;
  D. proc contents data=WORK _ALL_; run;
  C. proc contents data=WORK._all_; run;

• Question 214:

  Given the contents of the raw data file EMPLOYEE:

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

  Alan 19/2/2004 ACCT

  Rob 22/5/2004 MKTG

  MaryJane 14/3/2004 EDUC

  The following SAS program is submitted:

  data emps;

  infile `employee';

  input@1 name$

  @15 date

  @25 department$;

  run;

  Which INFORMAT correctly completes the program?

  A. date9.
  B. ddmmyyyy9.
  C. ddmmyy10.
  D. ddmmyyyy10.
  C. ddmmyy10.

• Question 215:

  The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

  

  The following SAS program is submitted:

  proc print data=WORK.ONE; where Num=contains (1); run;

  Which output is generated?

  

  A. B. C.
  D. No output is generated
  D. No output is generated

• Question 216:

  The following SAS program is submitted:

  proc sort data=SASUSER.PROJECTS out=PSORT;

  by Product Code descending Date Cost;

  run;

  Which of the following is true concerning the submitted program?

  A. The descending option applies only to the Date variable.
  B. The descending option applies to the Date and Cost variables.
  C. The descending option applies to the Product and Code variables.
  D. The descending option applies only to the Code variable.
  B. The descending option applies to the Date and Cost variables.

• Question 217:

  How many of the following SAS data set names are valid?

  

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

• Question 218:

  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 WORK.SALES_INFO are written to the WORK.REPORT data set?

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

• Question 219:

  The following program is submitted:

  proc sort data=SASUSER.PROJECTS out=PSORT;

  by Code descending Date Cost;

  run;

  Which of the following is true concerning the submitted program?

  A. The descending option applies to the variable Code.
  B. The variable Code is sorted by ascending order.
  C. The PSORT data set is stored in the SASUSER library.
  D. The descending option applies to the Date and Cost variables.
  B. The variable Code is sorted by ascending order.

• Question 220:

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

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

  24613 $25.31

  The following SAS program is submitted:

  data inventory;

  infile 'product';

  input idnum 5. @10 price;

  run;

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

  A. 25.31
  B. $25.31
  C. . (missing numeric value)
  D. No value is stored as the program fails to execute due to errors.
  C. . (missing numeric value)