SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 1:

  The following SAS program is submitted:

  data work.test;

  First = 'Ipswich, England';

  City_Country = substr(First,1,7)!!', '!!'England';

  run;

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

  A. 6
  B. 7
  C. 17
  D. 25
  D. 25

• Question 2:

  What is the purpose or the MISSOVER option on the INFILE statement?

  A. It prevents SAS from loading a new record when the end of the current record is reached.
  B. It enables SAS to scan the input data records until the character string that is specified in the @`character-string' expression is round.
  C. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.
  D. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.
  A. It prevents SAS from loading a new record when the end of the current record is reached.

• Question 3:

  There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

  

  What will be the value of NewVar when SAS writes the last observation?

  A. 451
  B. 1
  D. . (a missing value)
  A. 451

• Question 4:

  The following SAS program is submitted:

  data one;

  addressl = `214 London Way';

  run;

  data one;

  set one;

  address = tranwrd(address1, `Way', `Drive'); run;

  What are the length and value of the variable ADDRESS?

  A. Length is 14; value is `214 London Dri'.
  B. Length is 14; value is `214 London Way'.
  C. Length is 16; value is `214 London Drive'.
  D. Length is 200; value is `214 London Drive'.
  D. Length is 200; value is `214 London Drive'.

• Question 5:

  The following SAS program is submitted:

  

  How will the Exam variable value be displayed in the FREQ procedure output?

  A. Fail
  B. Pass
  C. 50.5
  D. . (missing numeric value)
  C. 50.5

• Question 6:

  The following SAS program is submitted:

  data work.total;

  set work.salary(keep = department wagerate);

  by department;

  if first.department

  then payroll = 0;

  payroll + wagerate;

  if last.department

  run;

  The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

  What is the result?

  A. The WORK.TOTAL data set contains 5 observations.
  B. The WORKTDTAL data set contains 100 observations.
  C. The WORKTOTAL data set contains 500 observations.
  D. The program fails to execute due to errors.
  A. The WORK.TOTAL data set contains 5 observations.

• Question 7:

  The following SAS program is submitted:

  Data_null_;

  set old;

  put sales 1 sales2;

  run;

  Where is the output written?

  A. to the SAS log
  B. to the SAS data set _NULL_
  C. to the SAS output window or to an output file
  D. to the raw data file that was most recently opened
  A. to the SAS log

• Question 8:

  The following SAS program is submitted: What new value would be assigned to X if its original value was a missing value?

  

  A. X would get a value of 1.
  B. X would get a value of 3.
  C. X would retain its original value of missing.
  D. This step does not run because of syntax errors.
  A. X would get a value of 1.

• Question 9:

  On which portion(s) of a SAS data set does the PRINT procedure report?

  A. the data portion only
  B. the descriptor portion only
  C. the descriptor portion and the data portion
  D. neither the data portion nor the descriptor portion
  A. the data portion only

• Question 10:

  The following SAS program is submitted:

  data ONE TWO SASUSER.TWO

  set SASUSER.ONE;

  run;

  Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

  A. 2 temporary and 1 permanent SAS data sets are created
  B. 3 temporary and 2 permanent SAS data sets are created
  C. 2 temporary and 2 permanent SAS data sets are created
  D. there is an error and no new data sets are created
  D. there is an error and no new data sets are created