SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 61:

  Read the table

  

  The following SAS program is submitted:

  proc freq data = sales;

  run;

  The following output is created by the FREQUENCY procedure:

  

  Which TABLES statement(s) completed the program and produced the output?

  A. tables region product;
  B. tables region * product;
  C. tables product * region;
  D. tables product; tables region;
  B. tables region * product;

• Question 62:

  The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed 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;

  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 63:

  Given the SAS data set WORK. PRODUCTS:

  

  The following SAS program is submitted:

  data WORK. REVENUE (drop=Sales Returns);

  set WORK. PRODUCTS (keep=ProdId Price Sales Returns);

  Revenue-Price* (Sales-Returns);

  run;

  How many variables does the WORK.REVENUE data set contain?

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

• Question 64:

  Given the following data step:

  

  After data step execution, what will data set WORK.GEO contain?

  

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

• Question 65:

  

  Given the following SAS log entry: What caused the error?

  A. The INPUT statement should be after the DATALINES statement.
  B. The CANCEL option is required with DATALINES.
  C. A semi-colon is missing on the DATALINES statement.
  D. Character data must be specified in quotes.
  C. A semi-colon is missing on the DATALINES statement.

• Question 66:

  The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

  

  What is the value of the variable Total before the first iteration of the data step?

  A. The value of the first observation's Wagerate.
  C. Missing
  D. Cannot be determined from the information given
  D. Cannot be determined from the information given

• Question 67:

  This question will ask you to provide a missing option. Given the following SAS program:

  

  Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?

  A. label = `*'
  B. labelsplit = `*'
  C. split = `*'
  D. wrap = `*'
  B. labelsplit = `*'

• Question 68:

  Given the contents of the raw data file TYPECOLOR.DAT:

  

  The following SAS program is submitted:

  

  What are the values of the variables Type and Color?

  A. Type=daisy, Color=yellow
  B. Type=daisy, Color=w
  C. Type=daisy, Color=daisyyellow
  D. Type=daisy, Color=
  D. Type=daisy, Color=

• Question 69:

  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 70:

  The SAS data set WORK.AWARDS is listed below:

  fname points

  Amy 2

  Amy 1

  Gerard 3

  Wang 3

  Wang 1

  Wang 2

  The following SAS program is submitted:

  proc sort data = work.awards;

  by descending fname points;

  run;

  Which one of the following represents how the observations are sorted?

  A. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1
  B. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1
  C. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1
  D. Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2
  D. Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2