SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 51:

  The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department.

  The following SAS program is submitted:

  

  What is the value of the variable Total before the first iteration of the data step?

  A. The value of the first observation's Wagerate.

  B. 0

  C. Missing

  D. Cannot be determined from the information given

  Correct Answer: D

• Question 52:

  The following SAS program is submitted:

  proc contents data=_all_; run;

  Which statement best describes the output from the submitted program?

  A. The output displays only a list of the SAS data sets that are contained in the WORK library.

  B. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.

  C. The output displays only the variables in the SAS data sets that are contained in the WORK library.

  D. The output displays only the metadata of the SAS data sets that are contained in the WORK library.

  Correct Answer: B

• Question 53:

  The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

  

  The following SAS program is submitted:

  

  What is output?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 54:

  The following program is submitted:

  proc contents data=_all_;

  Which statement best describes the output from the submitted program?

  A. The output displays only a list of the SAS data sets that are contained in the WORK library.

  B. The output displays only the contents of the SAS data sets that are contained in the WORK library.

  C. The output displays only the variables in the SAS data sets that are contained in the WORK library.

  D. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.

  Correct Answer: D

• Question 55:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :

  

  Which expression successfully completed the program and creates the variable DAY?

  A. day(BeginDate)

  B. weekday(BeginDate)

  C. dayofweek(BeginDate)

  D. getday(BeginDate,today())

  Correct Answer: B

• Question 56:

  Given the SAS data set WORK.ORDERS:

  

  The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS

  date value.

  A programmer would like to create a new variable called Note, that shows a character value with the

  Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the

  following: "Order 9341 shipped on 02FEB2009".

  Which of the following statement will correctly create the value and assign it to Note?

  A. note=catx(' ','Order',order_id,'shipped on',input(ship_date,date9.));

  B. note=catx(' ','Order',order_id,'shipped on',char(ship_date,date9.));

  C. note=catx(' ','Order',order_id,'shipped on',transwrd(ship_date,date9.));

  D. note=catx(' ','Order',order_id,'shipped on',put(ship_date,date9.));

  Correct Answer: D

• Question 57:

  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

  Correct Answer: B

• Question 58:

  The following SAS program is submitted:

  

  Which statement is true about the output data set?

  A. The label of the variable Jobcode is Job (only the first word).

  B. The label of the variable Jobcode is Job Desc (only the first 8 characters).

  C. The label of the variable Jobcode is Job Description.

  D. Labels can only be defined in PROC steps. The program fails to execute due to errors and the data set is not created.

  Correct Answer: C

• Question 59:

  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)

  Correct Answer: B

• Question 60:

  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.

  Correct Answer: C