SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 51:

  The contents or the raw data rile AMOUNT are listed below:

  ----|----10----|----20----|----30 $1,234

  The following SAS program is submitted:

  data test; infile `amount'; input@1 salary 6.; run;

  Which one of the following is the value or the SALARY variable?

  A. 1234
  B. 1,234
  C. $1,234
  D. . (missing numeric value)
  D. . (missing numeric value)

• Question 52:

  Click the Exhibit button to view two reports.

  

  Assume permanent variable labels have been assigned. The following SAS program is submitted and produces the first report:

  proc report data = sasuser.shoes nowd; column region subsidiary sales; define subsidiary / display; define region / group; define sales / sum;

  Which one of the following corrects the program above to produce the second report shown in the exhibit?

  A. Define the variable SUBSIDIARY with a SUM usage.
  B. Define the variable SUBSIDIARY with a GROUP usage.
  C. Define the variable SUBSIDIARY with an ORDER usage.
  D. Define the variable SUBSIDIARY with an ACROSS usage.
  B. Define the variable SUBSIDIARY with a GROUP usage.

• Question 53:

  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 item 1 $ 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 54:

  The following SAS program is submitted:

  data work.new;

  mon = 3;

  day = 23;

  year = 2000;

  date = mdy(mon,day,year); run;

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

  A. a character string with the value `23mar2000'
  B. a character string with the value `03/23/2000'
  C. a numeric value of 14692, which represents the SAS date value for March 23, 2000
  D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000
  C. a numeric value of 14692, which represents the SAS date value for March 23, 2000

• Question 55:

  The following SAS program is submitted:

  data work.products;

  Product_Number = 5461;

  Item = `1001';

  Item_Reference = ltem||'/'IlProduct_Number; run;

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

  A. 1001/5461
  B. 1001/ 5461
  C. . (missing numeric value)
  D. The value can not be determined as the program fails to execute due to errors.
  B. 1001/ 5461

• Question 56:

  Which one of the following statements is true regarding the name of a SAS array?

  A. It is saved with the data set.
  B. It can be used in procedures.
  C. It exists only for the duration of the DATA step.
  D. It can be the same as the name of a variable in the data set.
  C. It exists only for the duration of the DATA step.

• Question 57:

  The SAS data sets WORK.EMPLOYEE and WORKSALARY are listed below:

  WORK.EMPLOYEE WORK. SALARY

  name age name salary

  Bruce 30 Bruce 25000

  Dan 40 Bruce 35000

  Dan 25000

  The following SAS program is submitted:

  data work.empdata;

  merge work.employee

  work.salary;

  by fname;

  totsal + salary;

  run;

  How many variables are output to the WORK.EMPDATA data set?

  A. 3
  B. 4
  C. 5
  D. No variables are output to the data set as the program fails to execute due to errors.
  B. 4

• Question 58:

  The following SAS program is submitted:

  data revenue; set year_1; var1 = mdy(1,15,i960); run;

  Which one of the following values does the variable named VAR1 contain?

  A. 14
  B. 15
  C. 1151960
  D. `1/15/1960'
  A. 14

• Question 59:

  The SAS data sets WORKEMPLOYEE and WORKSALARY are shown below:

  WORK.EMPLOYEE WORK.SALARY

  fname age fname salary

  Bruce 30 Bruce 25000

  Dan 40 Bruce 35000

  Dan 25000

  The following SAS program is submitted:

  data work.empdata;

  by fname;

  totsal + salary;

  run;

  Which one of the following statements completes the merge of the two data sets by the ENAME variable?

  A. merge work.employee work.salary (fname = name);
  B. merge work.employee work.salary (name = fname);
  C. merge work.employee work.salary (rename = (fname = name));
  D. merge work.employee work.salary (rename = (name = fname));
  D. merge work.employee work.salary (rename = (name = fname));

• Question 60:

  The following SAS program is submitted:

  footnote1 `Sales Report for Last Month'; footnote2 `Selected Products Only'; footnote3 `All Regions';

  footnote4 `All Figures in Thousands of Dollars';

  proc print data = sasuser.shoes;

  footnote2 `All Products';

  run;

  Which one of the following contains the footnote text that is displayed in the report?

  A. All Products
  B. Sales Report for Last Month All Products
  C. All Products All Regions All Figures in Thousands of Dollars
  D. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars
  B. Sales Report for Last Month All Products