SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 71:

  Which one of the following is true when SAS encounters a data error in a DATA step?

  A. The DATA step stops executing at the point of the error, and no SAS data set is created.

  B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.

  C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.

  D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.

  Correct Answer: B

• Question 72:

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

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

  $1,234

  The following SAS program is submitted:

  data test;

  infile 'amount';

  input @1 salary 6.;

  if _error_ then description = 'Problems';

  else description = 'No Problems';

  run;

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

  A. Problems

  B. No Problems

  C. ' ' (missing character value)

  D. The value can not be determined as the program fails to execute due to errors.

  Correct Answer: A

• Question 73:

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

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

  Joe xx

  The following SAS program is submitted:

  data test;

  infile 'namenum';

  input name $ number;

  run;

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

  A. xx

  B. Joe

  C. . (missing numeric value)

  D. The value can not be determined as the program fails to execute due to errors.

  Correct Answer: C

• Question 74:

  When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000

  observations:

  libname sasdata 'SAS-data-library';

  options obs = 500;

  proc print data = sasdata.prdsales (firstobs = 100);

  run;

  options obs = max;

  proc means data = sasdata.prdsales (firstobs = 500);

  run;

  How many observations are processed by each procedure?

  A. 400 for PROC PRINT 4500 for PROC MEANS

  B. 401 for PROC PRINT 4501 for PROC MEANS

  C. 401 for PROC PRINT 4500 for PROC MEANS

  D. 500 for PROC PRINT 5000 for PROC MEANS

  Correct Answer: B

• Question 75:

  Which one of the following is true of the SUM statement in a SAS DATA step program?

  A. It is only valid in conjunction with a SUM function.

  B. It is not valid with the SET, MERGE and UPDATE statements.

  C. It adds the value of an expression to an accumulator variable and ignores missing values.

  D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

  Correct Answer: C

• Question 76:

  The following SAS program is submitted:

  proc print data = sasuser.houses; run;

  proc means data = sasuser.shoes; run; Which one of the following OPTIONS statements resets the page number to 1 for the second report?

  A. options pageno = 1;

  B. options pagenum = 1;

  C. options reset pageno = 1;

  D. options reset pagenum = 1;

  Correct Answer: A

• Question 77:

  The following SAS program is submitted:

  libname rawdata1 'location of SAS data library';

  filename rawdata2 'location of raw data file';

  data work.testdata;

  infile

  input sales1 sales2;

  run;

  Which one of the following is needed to complete the program correctly?

  A. rawdata1

  B. rawdata2

  C. 'rawdata1'

  D. 'rawdata2'

  Correct Answer: B

• Question 78:

  The following SAS program is submitted and reads 100 records from a raw data file:

  data work.total;

  infile 'file-specification' end = eof;

  input name $ salary;

  totsal + salary;

  run;

  Which one of the following IF statements writes the last observation to the output data set?

  A. if end = 0;

  B. if eof = 0;

  C. if end = 1;

  D. if eof = 1;

  Correct Answer: D

• Question 79:

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

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

  chair,,table

  chair,couch,table

  The following SAS program is submitted:

  data stock;

  infile 'furniture' dsd;

  input item1 $ item2 $ item3 $;

  run;

  Which one of the following is the value of the variable named ITEM2 in the first observation of the output

  data set?

  A. table

  B. ,table

  C. . (missing numeric value)

  D. ' ' (missing character value)

  Correct Answer: D

• Question 80:

  A raw data file is listed below:

  RANCH,1250,2,1,Sheppard Avenue,"$64,000"

  SPLIT,1190,1,1,Rand Street,"$65,850"

  CONDO,1400,2,1.5,Market Street,"80,050"

  TWOSTORY,1810,4,3,Garris Street,"$107,250"

  RANCH,1500,3,3,Kemble Avenue,"$86,650"

  SPLIT,1615,4,3,West Drive,"94,450"

  SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

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

  data work.condo_ranch;

  infile 'file-specification' dsd;

  input style $ @;

  if style = 'CONDO' or style = 'RANCH' then

  input sqfeet bedrooms baths street $ price : dollar10.;

  run;

  How many observations does the WORK.CONDO_RANCH data set contain?

  A. 0

  B. 3

  C. 5

  D. 7

  Correct Answer: D