SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 241:

  The SAS data set PETS is sorted by the variables TYPE and BREED.

  The following SAS program is submitted:

  proc print data = pets;

  var type breed;

  sum number;

  run;

  What is the result?

  A. The SUM statement produces only a grand total of NUMBER.
  B. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
  C. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
  D. Nothing is produced by the SUM statement; the program fails to execute.
  A. The SUM statement produces only a grand total of NUMBER.

• Question 242:

  The following SAS program is submitted:

  data work.new;

  mon = 3;

  day = 23;

  year = 2000;

  date = mdy(mon,day,year);

  run;

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

  A. a character string with the value '23mar2000'
  B. a character string with the value '03/23/2000'
  C. a numeric value of 14692, which represents the SAS date value for March 23, 2000
  D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000
  C. a numeric value of 14692, which represents the SAS date value for March 23, 2000

• Question 243:

  The following SAS program is submitted:

  

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

  A. 6
  B. 7
  C. 8
  D. . (missing numeric)
  B. 7

• Question 244:

  The SASDATA.BANKS data set has five observations when the following SAS program is submitted:

  libname sasdata 'SAS-data-library';

  data allobs;

  set sasdata.banks;

  capital=0;

  do year = 2000 to 2020 by 5;

  capital + ((capital+2000) * rate);

  output;

  end;

  run;

  How many observations will the ALLOBS data set contain?

  A. 5
  B. 15
  C. 20
  D. 25
  D. 25

• Question 245:

  The following SAS program is submitted:

  libname temp 'SAS-data-library';

  data work.new;

  set temp.jobs;

  format newdate mmddyy10.;

  qdate = qtr(newdate);

  ddate = weekday(newdate);

  run;

  proc print data = work.new;

  run;

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

  What output is produced if April 15, 2000 falls on a Saturday?

  A. Obs newdate qdate ddate 1 APR152000 2 6
  B. Obs newdate qdate ddate 1 04/15/2000 2 6
  C. Obs newdate qdate ddate 1 APR152000 2 7
  D. Obs newdate qdate ddate 1 04/15/2000 2 7
  D. Obs newdate qdate ddate 1 04/15/2000 2 7

• Question 246:

  The following SAS program is submitted:

  

  How many raw data records are read during each iteration of the DATA step?

  A. 1
  B. 2
  C. 3
  D. 4
  B. 2

• Question 247:

  Given the SAS data set WORK.EMP_NAME:

  

  Given the SAS data set WORK.EMP_DEPT:

  

  The following program is submitted:

  

  How many observations are in data set WORK.ALL after submitting the program?

  A. 1
  B. 2
  C. 3
  D. 5
  B. 2

• Question 248:

  Given the SAS data set PEPM.STUDENTS:

  PERM.STUDENTS NAME AGE

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

  Alice13

  Barbara13

  Carol14

  The following SAS program is submitted:

  libname perm `SAS data library';

  data students;

  set perm.students;

  file `file specification';

  put name $15. @5 age 2.;

  run;

  What is written to the output raw data file?

  A. ----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14
  B. ----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
  C. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
  D. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14
  B. ----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4

• Question 249:

  Which program displays a listing of all data sets in the SASUSER library?

  A. proc contents lib = sasuser.all; run;
  B. proc contents data = sasuser.all; run;
  C. proc contents lib = sasuser._alI_; run;
  D. proc contents data = sasuser._all_; run;
  D. proc contents data = sasuser._all_; run;

• Question 250:

  The following SAS program is submitted: What is the result?

  

  A. The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.
  B. The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
  C. The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.
  D. The variable Discount in the output data set is set to zero. No messages are written to the SAS log.
  C. The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.