SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 261:

  The following SAS program is submitted:

  data test;

  set chemists;

  jobcode = `Chem2'

  then description = `Senior Chemist';

  else description = `Unknown';

  run;

  The value for the variable JOBCODE is:

  JOBCODE

  chem2

  What is the value of the variable DESCRIPTION?

  A. chem2
  B. Unknown
  C. Senior Chemist
  D. ` ` (missing character value)
  B. Unknown

• Question 262:

  Which statement is true concerning the SAS automatic variable _ERROR_?

  A. It cannot be used in an if/then condition.
  B. It cannot be used in an assignment statement.
  C. It can be put into a keep statement or keep= option.
  D. It is automatically dropped.
  D. It is automatically dropped.

• Question 263:

  The following SAS program is submitted:

  data work.one;

  x = 3;

  y = 2;

  z = x ** y;

  run;

  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 fails to execute due to errors.
  B. 9

• Question 264:

  The following SAS program is submitted:

  data work.month; date = input('13mar2000',date9.); run;

  Which one of the following represents the type and length of the variable DATE in the output data set?

  A. numeric, 8 bytes
  B. numeric, 9 bytes
  C. character, 8 bytes
  D. character, 9 bytes
  A. numeric, 8 bytes

• Question 265:

  The following SAS program is submitted once:

  

  Which procedure output will appear in test.html?

  A. Only the FREQ procedure output
  B. Only the PRINT procedure output
  C. No procedure output due to syntax errors
  D. Both the PRINT procedure and FREQ procedure output
  C. No procedure output due to syntax errors

• Question 266:

  A raw data file is listed below:

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

  squash 1.10

  apples 2.25

  juice 1.69

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

  data groceries;

  infile 'file-specification';

  input item $ cost;

  run;

  Which one of the following completes the program and produces a grand total for all COST values?

  A. grandtot = sum cost;
  B. grandtot = sum(grandtot,cost);
  C. retain grandtot 0; grandtot = sum(grandtot,cost);
  D. grandtot = sum(grandtot,cost); output grandtot
  C. retain grandtot 0; grandtot = sum(grandtot,cost);

• Question 267:

  The following SAS program is submitted:

  data WORK.ONE;

  Text='Australia, US, Denmark';

  Pos=find(Text,'US','i',5);

  run;

  What value will SAS assign to Pos?

  B. 1
  C. 2
  D. 12
  D. 12

• Question 268:

  The following SAS program is submitted:

  libname temp `SAS data library';

  data work.new;

  set temp.jobs;

  format newdate mmddw10.;

  mdate = month(newdate);

  ddate = weekday(newdate);

  run;

  proc print data = work.new; run;

  The variable NEWDATE contains the SAS date value for April 15. 2005.

  What output is produced if April 15, 2005 falls on a Friday?

  A. Obsnewdate mdate ddate 104/15/2005 APR 6
  B. Obs newdate mdate ddate 104/15/2005 4 6
  C. Obs newdate mdate ddate 104/15/2005 APR 7
  D. Obs newdate mdate ddate 104/15/2005 4 7
  B. Obs newdate mdate ddate 104/15/2005 4 6

• Question 269:

  Consider the following data step:

  

  The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement. Which statement regarding this program is true?

  A. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
  B. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.
  C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
  D. City's value will be assigned one time, State's value 5 times.
  D. City's value will be assigned one time, State's value 5 times.

• Question 270:

  This question will ask you to provide a line of missing code.

  The following SAS program is submitted:

  proc freq data = WORK.SALES;

  run;

  The following output is created by the FREQUENCY procedure:

  

  Which statement was used to complete the above program that produced the output?

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