SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 11:

  The following SAS program is submitted:

  data work.test;

  set work.staff (keep = jansales febsales marsales);

  array diff_sales{3} difsales1 - difsales3;

  array monthly{3} jansales febsales marsales;

  run;

  What new variables are created?

  A. JANSALES, FEBSALES and MARSALES
  B. MONTHLY1, MONTHLY2 and MONTHLY3
  C. DIFSALES1, DIFSALES2 and DIFSALES3
  D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
  C. DIFSALES1, DIFSALES2 and DIFSALES3

• Question 12:

  Which of the following programs correctly invokes the DATA Step Debugger?

  

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

• Question 13:

  Given the SAS data set SASDATA TWO:

  SASDATA TWO X Y

  5 2

  3 1

  5 6

  The following SAS program is submitted:

  data sasuser.one two sasdata.three;

  set sasdata two;

  if x = 5 then output sasuser.one;

  else output sasdata two;

  run;

  What is the result?

  A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations
  B. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations
  C. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations
  D. No data sets are output. The DATA step fails execution due to syntax errors.
  D. No data sets are output. The DATA step fails execution due to syntax errors.

• Question 14:

  Given the SAS data set WORK.ONE:

  

  What value will SAS assign to Total?

  A. 3
  B. 1.6
  C. 4.8
  D. The program fails to execute due to errors.
  B. 1.6

• Question 15:

  Given the following raw data records in TEXTFILE.TXT:

  

  The following output is desired:

  

  Which SAS program correctly produces the desired output?

  

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

• Question 16:

  Which one of the following statements is true regarding the name of a SAS array?

  A. It is saved with the data set.
  B. It can be used in procedures.
  C. It exists only for the duration of the DATA step.
  D. It can be the same as the name of a variable in the data set.
  C. It exists only for the duration of the DATA step.

• Question 17:

  Given the SAS data set PERM.STUDENTS:

  PERM.STUDENTS NAME AGE

  --------- ------- Alfred 14

  Alice 13

  Barbara 13

  Carol 14

  The following SAS program is submitted:

  libname perm `SAS data library';

  data students;

  set perm.students;

  file `file specification';

  put name $ age;

  run;

  The following double-spaced file is desired as output

  Alfred 14

  Alice 13

  Barbara 13

  Carol 14

  Which statement completes the program and creates the desired file?

  A. put
  B. put/;
  C. double;
  D. put _null_;
  A. put

• Question 18:

  The Excel workbook QTR1.XLS contains the following three worksheets:

  JAN FEB MAR

  Which statement correctly assigns a library reference to the Excel workbook?

  A. libname qtrdata 'qtr1.xls';
  B. libname 'qtr1.xls' sheets=3;
  C. libname jan feb mar 'qtr1.xls';
  D. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);
  A. libname qtrdata 'qtr1.xls';

• Question 19:

  The following SAS program is submitted:

  data temp.x; set sasuser.y; run;

  What must be submitted prior to this SAS program for the program to execute successfully?

  A. A LIBNAME statement for the libref TEMP only must be submitted.
  B. A LIBNAME statement for the libref SASUSER only must be submitted.
  C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
  D. No LIBNAME statement needs to be submitted.
  A. A LIBNAME statement for the libref TEMP only must be submitted.

• Question 20:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 4;

  it amount = 4 then word = `FOUR';

  else if amount = 7

  then word = `SEVEN';

  else word = `NONE!!!';

  amount = 7;

  run;

  What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

  A. amount word 4 FOUR
  B. amount word 4 NONE!!!
  C. amount word 7 FOUR
  D. amount word 7 SEVEN
  C. amount word 7 FOUR