SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 91:

  The following SAS program is submitted;

  data combine;

  country = `Italy, Russia, ireland';

  found = find(country, `i');

  run;

  What is the value of the variable FOUND in the output data set?

  A. 1
  B. 12
  C. Italy
  D. Russia
  B. 12

• Question 92:

  The following SAS program is submitted:

  data work.products;

  Product_Number = 5461;

  Item = '1001';

  Item_Reference = Item'/'Product_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.
  D. The value can not be determined as the program fails to execute due to errors.

• Question 93:

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

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

  $1,234

  The following SAS program is submitted:

  data test;

  infile 'amount';

  input @1 salary 6.;

  if _error_ then description = 'Problems';

  else description = 'No Problems';

  run;

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

  A. Problems
  B. No Problems
  C. ' ' (missing character value)
  D. The value can not be determined as the program fails to execute due to errors.
  A. Problems

• Question 94:

  A raw data file is listed below:

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

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

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

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

  RANCH,1500,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';

  input sqfeet bedrooms baths street $ price : dollar10.;

  run;

  How many observations will the output data set contain?

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

• Question 95:

  After a SAS program is submitted, the following is written to the SAS log:

  105 data WORK.JANUARY;

  106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);

  107 if Month='JAN' then output WORK.JANUARY;

  108 Sales=Cost * Quantity;

  109 drop=Month Quantity Cost;

  ERROR 22-322: Syntax error, expecting one of the following: !,

  !!, , *, **, +, -,

  , <=, <>, =, >, >=,

  AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,

  NOTIN, OR, ^=, |, ||, ~=.

  110 run;

  What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?

  A. (drop Month Quantity Cost)
  B. (drop Month, Quantity, Cost)
  C. (drop=Month, Quantity, Cost)
  D. (drop=Month Quantity Cost)
  D. (drop=Month Quantity Cost)

• Question 96:

  Given the SAS data set WORK.ONE:

  

  And the SAS data set WORK.TWO:

  

  The following program is submitted:

  

  What is the first observation in the SAS data set WORK.BOTH?

  

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

• Question 97:

  Given the data sets below: WORK.EMP with variables:

  

  WORK.NEWHIRE with variables:

  

  The following SAS program is submitted:

  

  The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations. How many variables will the data set WORK.ALLEMP contain?

  A. 3
  B. The program fails execution.
  C. 6
  D. 4
  A. 3

• Question 98:

  The following SAS program is submitted:

  

  If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

  A. ' ' (missing character value)
  B. Unknown
  C. Senior Pilot
  D. SENIOR PILOT
  B. Unknown

• Question 99:

  When SAS encounters a data when reading from a raw data file, which action will occur?

  A. SAS will write an ERROR message to the SAS log and suspend execution.
  B. SAS will write a WARNING message to the SAS log and suspend execution.
  C. SAS will write a NOTE to the SAS log and continue execution.
  D. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
  D. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.

• Question 100:

  A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.

  What will happen?

  A. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.
  B. A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
  C. The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
  D. The program will produce an error message indicating that the exceldata.xlsx workbook already exists.
  A. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.