SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 41:

  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 WORKTOTALSALES data set.
  B. The program fails execution due to syntax errors.

• Question 42:

  A raw data record is listed below:

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

  Printing 750

  The following SAS program is submitted:

  data bonus; infile `file-specification'; input dept $ 1-11 number 13-15;

  run;

  Which one of the following SAS statements completes the program and results in a value of `Printing 750' for the DEPARTMENT variable?

  A. department = trim(dept) II number;
  B. department = dept II input(number,3.);
  C. department = trim(dept) II put(number,3.);
  D. department = input(dept,11.) II input(number,3.);
  C. department = trim(dept) II put(number,3.);

• Question 43:

  The following SAS program is submitted:

  data work.one;

  x = 3;

  y = 2;

  z = x ** y;

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

  A. 6
  B. 9
  C. (missing numeric value)
  D. The program tails to execute due to errors.
  B. 9

• Question 44:

  Which one of the following statements is true regarding the SAS automatic _ERROR_ variable?

  A. The _ERROR_ variable contains the values `ON' or `OFF'.
  B. The _ERROR_ variable contains the values `TRUE' or `FALSE'.
  C. The _ERROR_ variable is automatically stored in the resulting SAS data set.
  D. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
  D. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

• Question 45:

  A raw data file is listed below:

  RANCH, 1250,2,1 Sheppard Avenue,"$64,000"

  SPLIT,1 190,1,1 Rand Street"$65,850"

  CONDO,1400,2,1.5,Market Street,"80,050"

  TWOSTORY,1810,4,3,Garris Street,"$107,250"

  RANCH,1 500 ,3,3,Kemble Avenue "$86,650"

  SPLIT, 1615,4,3 ,West Drive,"94,450"

  SPLIT, 1305,3,1.5,Graham Avenue "$73,650"

  The following SAS program is submitted using the raw data file as input:

  data work.condo_ranch

  infile `file-specification' dsd

  input style $ @;

  if style = `CONDO' or style = `RANCH' then

  input sqfeet bedrooms baths street $ price : dollar10.; run;

  How many observations does the WORK.CONDO_RANCH data set contain?

  B. 3
  C. 5
  D. 7
  D. 7

• Question 46:

  The following SAS program is submitted:data work.passengers;

  data work.passengers;

  if OrigPassengers = then

  OrigPassengers = 100;

  TransPassengers = 100;

  OrigPassengers = .;

  NonPaying = 10;

  TotalPassengers = OrigPassengers + TransPassengers; run;

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

  A. 100
  B. 110
  C. 200
  D. (missing numeric value)
  B. 110

• Question 47:

  The following SAS program is submitted:

  data work.empsalary;

  set work.people (in = inemp)

  work.money (in = insal):

  if insal and inemp;

  run;

  The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations.

  How many observations will the data set WORK.EMPSALARY contain?

  B. 5
  C. 7
  D. 12
  A

• Question 48:

  The following SAS program is submitted:

  proc means data = sasuser.shoes;

  where product in (`Sandal' , `Slipper' , `Boot');

  run;

  Which one of the following ODS statements completes the program and sends the report to an HTML file?

  A. ods html = `sales.html';
  B. ods file = `sales.html';
  C. ods file html = `sales.html';
  D. ods html file = `sales.html';
  D. ods html file = `sales.html';

• Question 49:

  The following SAS program is submitted;

  data work.test;

  First = `lpswich, England';

  City = substr(First,1,7);

  City_Country = City!!' , `!!`England';

  run;

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

  A. lpswich!!
  B. lpswich, England
  C. lpswich, `England'
  D. lpswich , England
  D. lpswich , England

• Question 50:

  Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

  A. non-missing numeric variable values only
  B. missing numeric variable values and non-missing numeric variable values only
  C. nun-missing character variables and nun-missing numeric variable values only
  D. missing character variables, nun-missing character variables, missing numeric variable values, and nun-missing numeric variable values
  A. non-missing numeric variable values only