SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 231:

  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

  Correct Answer: C

• Question 232:

  What describes the SAS automatic _ERROR_ variable?

  A. The _ERROR_ variable contains the values `TRUE' or `FALSE.'

  B. The _ERROR variable maintains a count of the number of data errors.

  C. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

  D. The ERROR_variable contains the number or the observation that caused the error.

  Correct Answer: C

• Question 233:

  Given the following raw data record:

  07Jan2005

  Which INFORMAT reads this raw data and stores it as a SAS date value?

  A. dmy9.

  B. date9.

  C. ddMMMyy9.

  D. ddmmmyyyy9.

  Correct Answer: B

• Question 234:

  Which statement correctly computes the average of four numerical values?

  A. average = mean(num1, num4);

  B. average = mean(num1 - num4);

  C. average = mean(ofnum1 - num4)

  D. average = mean(num1 num2 num3 num4);

  Correct Answer: C

• Question 235:

  The following SAS program is submitted:

  libname temp `SAS data library'; data temp.sales;

  merge temp.sales

  work.receipt;

  by names;

  run;

  The input data files are sorted by the NAMES variable:

  What is the result?

  A. The program executes successfully and a temporary SAS data set is created.

  B. The program executes successfully and a permanent SAS data set is created.

  C. The program fails execution because the same SAS data set is referenced for both read and write operations.

  D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.

  Correct Answer: B

• Question 236:

  The following SAS program is submitted:

  libname temp `SAS data library';

  data work.new;

  set temp.jobs;

  format newdate mmddw10.;

  mdate = month(newdate);

  ddate = weekday(newdate);

  run;

  proc print data = work.new; run;

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

  What output is produced if April 15, 2005 falls on a Friday?

  A. Obsnewdate mdate ddate 104/15/2005 APR 6

  B. Obs newdate mdate ddate 104/15/2005 4 6

  C. Obs newdate mdate ddate 104/15/2005 APR 7

  D. Obs newdate mdate ddate 104/15/2005 4 7

  Correct Answer: B

• Question 237:

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

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

  24613 $25.31

  The following SAS program is submitted:

  data inventory;

  infile 'product';

  input idnum 5. @10 price;

  run;

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

  A. 25.31

  B. $25.31

  C. . (missing numeric value)

  D. No value is stored as the program fails to execute due to errors.

  Correct Answer: C

• Question 238:

  The following SAS program is submitted: proc contents data = sashelp.class varnum; quit;

  What does the VARNUM option print?

  A. a list of variable names

  B. the total number of variables

  C. a list of the variables in alphabetic order

  D. a list of the variables in the order they were created

  Correct Answer: D

• Question 239:

  The following SAS program is submitted:

  data test;

  set chemists;

  jobcode = `Chem2'

  then description = `Senior Chemist';

  else description = `Unknown';

  run;

  The value for the variable JOBCODE is:

  JOBCODE

  chem2

  What is the value of the variable DESCRIPTION?

  A. chem2

  B. Unknown

  C. Senior Chemist

  D. ` ` (missing character value)

  Correct Answer: B

• Question 240:

  Given the AIRPLANES data set

  AlRPLANES TYPE MPG

  F-18 105 C-130 25 Harrier 75 A-6 110

  The following SAS program is submitted:

  data gt100;

  set airplanes(keep = type mpg load);

  load = mpg * 150;

  run;

  The program fails to execute due to syntax errors.

  What is the cause of the syntax error?

  A. MPG is not a numeric variable.

  B. LOAD is not a variable in the data set GT100.

  C. LOAD is not variable in the data set AIRPLANES.

  D. LOAD must be defined prior to the SET statement.

  Correct Answer: C