SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 91:

  The following SAS program is submitted:

  data work.report;

  set work.sales_info;

  if qtr(sales_date) ge 3;

  run;

  The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the

  variable SALES_DATE which contains a SAS date value for each of the twelve months.

  How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT

  data set?

  A. 2

  B. 3

  C. 6

  D. 9

  Correct Answer: C

• Question 92:

  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

  Correct Answer: D

• Question 93:

  The contents of the SAS data set PERM.JAN_SALES are listed below:

  VARIABLE NAME TYPE

  idnum character variable

  sales_date numeric date value

  A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The

  SALES_DATE values need to be in a MMDDYY10 form.

  Which one of the following SAS DATA steps correctly creates this raw data file?

  A. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dsd = ','; put idnum sales_date : mmddyy10.; run;

  B. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dlm = ','; put idnum sales_date : mmddyy10.; run;

  C. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dlm = ','; run;

  D. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dsd = ','; run;

  Correct Answer: B

• Question 94:

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

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

  Janice 10

  Henri 11

  Michael 11

  Susan 12

  The following SAS program is submitted:

  data group;

  infile 'team';

  input name $15. age 2.;

  file 'file-specification';

  put name $15. +5 age 2.;

  run;

  Which one of the following describes the output created?

  A. a raw data file only

  B. a SAS data set named GROUP only

  C. a SAS data set named GROUP and a raw data file

  D. No output is generated as the program fails to execute due to errors.

  Correct Answer: C

• Question 95:

  The following SAS program is submitted:

  data allobs;

  set sasdata.origin (firstobs = 75 obs = 499);

  run;

  The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observations does the ALLOBS data set contain?

  A. 424

  B. 425

  C. 499

  D. 1000

  Correct Answer: B

• Question 96:

  The following SAS program is submitted:

  data _null_;

  set old (keep = prod sales1 sales2);

  file 'file-specification';

  put sales1 sales2;

  run;

  Which one of the following default delimiters separates the fields in the raw data file created?

  A. : (colon)

  B. (space)

  C. , (comma)

  D. ; (semicolon)

  Correct Answer: B

• Question 97:

  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

  Correct Answer: D

• Question 98:

  A raw data file is listed below:

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

  John McCloskey 35 71

  June Rosesette 10 43

  Tineke Jones 9 37

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

  data work.homework;

  infile 'file-specification';

  input name $ age height;

  if age LE 10;

  run;

  How many observations will the WORK.HOMEWORK data set contain?

  A. 0

  B. 2

  C. 3

  D. No data set is created as the program fails to execute due to errors.

  Correct Answer: C

• Question 99:

  The following SAS program is submitted:

  proc contents data = sasuser.airplanes; run;

  Which one of the following is produced as output?

  A. the data portion of every data set in the SASUSER library

  B. the data portion of the data set SASUSER.AIRPLANES only

  C. the descriptor portion of every data set in the SASUSER library

  D. the descriptor portion of the data set SASUSER.AIRPLANES only

  Correct Answer: D

• Question 100:

  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

  Correct Answer: A