SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 61:

  The following SAS program is submitted:

  

  Which statement is true about the output data set?

  A. The type of the variable CharEmpid is numeric.

  B. The type of the variable CharEmpid is unknown.

  C. The type of the variable CharEmpid is character.

  D. The program fails to execute due to errors.

  Correct Answer: D

• Question 62:

  The following SAS program is submitted:

  

  What is the value of the second variable in the data set WORK.AUTHORS?

  A. Hemingway

  B. Hemingwa

  C. ' ' (a missing value)

  D. The program contains errors. No variables are created.

  Correct Answer: B

• Question 63:

  After a SAS program is submitted, the following is written to the SAS log:

  

  What changes should be made to the KEEP statement to correct the errors in the LOG?

  A. keep=(Product Sales);

  B. keep Product, Sales;

  C. keep=Product, Sales;

  D. keep Product Sales;

  Correct Answer: D

• Question 64:

  Given the SAS data set WORK.P2000:

  

  And the SAS data set WORK.P2008:

  

  The following output is desired:

  

  Which SAS program correctly combines the data?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 65:

  Given the contents of the raw data file 'EMPLOYEE.TXT'

  

  Which SAS informat correctly completes the program?

  A. date9

  B. mmddyy10

  C. ddmmyy10

  D. mondayyr10

  Correct Answer: B

• Question 66:

  The following SAS program is submitted:

  

  If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

  A. ' ' (missing character value)

  B. Unknown

  C. Senior Pilot

  D. SENIOR PILOT

  Correct Answer: B

• Question 67:

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

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

  01012000

  The following SAS program is submitted:

  data test;

  infile 'calendar';

  input @1 date mmddyy10.;

  if date = '01012000'd then event = 'January 1st';

  run;

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

  A. 01012000

  B. January 1st

  C. . (missing numeric value)

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

  Correct Answer: D

• Question 68:

  The following SAS program is submitted:

  data work.january;

  set work.allmonths (keep = product month num_sold cost);

  if month = 'Jan' then output work.january;

  sales = cost * num_sold;

  keep = product sales;

  run;

  Which variables does the WORK.JANUARY data set contain?

  A. PRODUCT and SALES only

  B. PRODUCT, MONTH, NUM_SOLD and COST only

  C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

  D. An incomplete output data set is created due to syntax errors.

  Correct Answer: D

• Question 69:

  The following SAS program is submitted:

  data work.totalsales;

  set work.monthlysales(keep = year product sales);

  retain monthsales {12} ;

  array monthsales {12} ;

  do i = 1 to 12;

  monthsales{i} = sales;

  end;

  cnt + 1;

  monthsales{cnt} = sales;

  run;

  The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a

  total of 60 observations.

  Which one of the following is the result of the above program?

  A. The program fails execution due to data errors.

  B. The program fails execution due to syntax errors.

  C. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.

  D. The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations

  Correct Answer: B

• Question 70:

  The following SAS program is submitted:

  data work.totalsales (keep = monthsales{12} );

  set work.monthlysales (keep = year product sales);

  array monthsales {12} ;

  do i=1 to 12;

  monthsales{i} = sales;

  end;

  run;

  The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a

  total of 60 observations.

  Which one of the following is the result of the above program?

  A. The program fails execution due to data errors.

  B. The program fails execution due to syntax errors.

  C. The program executes with warnings and creates the WORK.TOTALSALES data set.

  D. The program executes without errors or warnings and creates the WORK.TOTALSALES data set

  Correct Answer: B