SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 191:

  The following SAS program is submitted:

  data work.totalsales (keep = monthsales{12} );

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

  array monthsales {12} ;

  do i=1 to 12;

  monthsales{i} = sales;

  end;

  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 executes with warnings and creates the WORK.TOTALSALES data set.
  D. The program executes without errors or warnings and creates the WORK.TOTALSALES data set
  B. The program fails execution due to syntax errors.

• Question 192:

  The following SAS program is submitted:

  

  How many observations are written to the WORK.SALES data set?

  B. 1
  C. 5
  D. 60
  B. 1

• Question 193:

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

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

  72 95

  The following SAS program is submitted:

  data test;

  infile 'size';

  input @1 height 2. @4 weight 2;

  run;

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

  A. 2
  B. 72
  C. 95
  D. . (missing numeric value)
  A. 2

• Question 194:

  The following SAS program is submitted:

  data work.test;

  Title = 'A Tale of Two Cities, Charles J. Dickens';

  Word = scan(title,3,' ,');

  run;

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

  A. T
  B. of
  C. Dickens
  D. ' ' (missing character value)
  D. ' ' (missing character value)

• Question 195:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :

  

  Which expression successfully completed the program and creates the variable DAY?

  A. day(BeginDate)
  B. weekday(BeginDate)
  C. dayofweek(BeginDate)
  D. getday(BeginDate,today())
  B. weekday(BeginDate)

• Question 196:

  A raw data record is listed below:

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

  1999/10/25

  The following SAS program is submitted:

  data projectduration;

  infile 'file-specification';

  input date $ 1 - 10;

  run;

  Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?

  A. duration = today( ) - put(date,ddmmyy10.);
  B. duration = today( ) - put(date,yymmdd10.);
  C. duration = today( ) - input(date,ddmmyy10.);
  D. duration = today( ) - input(date,yymmdd10.);
  D. duration = today( ) - input(date,yymmdd10.);

• Question 197:

  The following SAS program is submitted:

  proc sort data = sasuser.houses out = houses;

  by style;

  run;

  proc print data = houses;

  run;

  Click on the Exhibit button to view the report produced.

  style bedrooms baths price

  CONDO 2 1.5 80050

  3 2.5 79350

  4 2.5 127150

  2 2.0 110700 RANCH 2 1.0 64000

  3 3.0 86650

  3 1.0 89100

  1 1.0 34550 SPLIT 1 1.0 65850

  4 3.0 94450

  3 1.5 73650 TWOSTORY 4 3.0 107250

  2 1.0 55850

  2 1.0 69250

  4 2.5 102950

  Which of the following SAS statement(s) create(s) the report?

  A. id style;
  B. id style; var style bedrooms baths price;
  C. id style; by style; var bedrooms baths price;
  D. id style; by style; var style bedrooms baths price;
  C. id style; by style; var bedrooms baths price;

• Question 198:

  The following SAS program is submitted:

  data work.test;

  array agents{4} $ 12 sales1 - sales4;

  run;

  Which one of the following represents the variables that are contained in the output data set?

  A. SALES1, SALES2, SALES3, SALES4
  B. AGENTS1, AGENTS2, AGENTS3, AGENTS4
  C. None, the DATA step fails because the ARRAY statement can reference only numeric data.
  D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.
  A. SALES1, SALES2, SALES3, SALES4

• Question 199:

  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 footnote(s) is/are 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

• Question 200:

  Given the SAS data set WORK.TEMPS:

  

  The following program is submitted:

  

  Which output is correct?

  

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