SASInstitute SAS Institute Systems Certification A00-211 Questions & Answers

• Question 41:

  This question will ask you to provide a line of missing code: Given the SAS data set WORK.EMPLOYEE_UNFO:

  

  The following SAS program is submitted:

  

  In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.

  A. Check the answer in explanation.

  Correct Answer: A

  by IDNumber Expenses; IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12

• Question 42:

  Given the SAS data set WORK.ORDERS:

  

  Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009'

  Which statement will create the new variable Ship_date_char as a character value with a format such as "February 2, 2009"?

  A. Ship_date_char = input(Ship_date, date9.,worddate20.);

  B. Ship_date_char = put(Ship_date, date9.,worddate20.);

  C. Ship_date_char = input(Ship_date,worddate20.);

  D. Ship_date_char = put(Ship_date,worddate20.);

  Correct Answer: D

• Question 43:

  The following SAS program is submitted: What new value would be assigned to X if its original value was a missing value?

  

  A. X would get a value of 1.

  B. X would get a value of 3.

  C. X would retain its original value of missing.

  D. This step does not run because of syntax errors.

  Correct Answer: A

• Question 44:

  This question will ask you to provide a segment of missing code. Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  The data set WORK.TWO is created, where Day would be the day of the month:

  

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

  A. day(BeginDate)

  B. weekday(BeginDate)

  C. dayofmonth(BeginDate)

  D. getday(BeginDate)

  Correct Answer: B

• Question 45:

  The following SAS program is submitted:

  

  What value will SAS assign to Pos?

  A. 12

  Correct Answer: A

• Question 46:

  The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;

  The following SAS program is submitted:

  

  What are the formats of the variables LocalFee and CountryFee in the output data set?

  A. LocalFee has format of 9. and CountryFee has a format of percent7.2

  B. LocalFee has format of 9. and CountryFee has a format of 7.

  C. Both LocalFee and CountryFee have a format of percent7.2

  D. The data step fails execution; there is no format for LocalFee.

  Correct Answer: C

• Question 47:

  Given the following IF/THEN statement:

  If Age NE 16 and Age NE 15 then Group-1;

  Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?

  A. if (Age NE 16) or (Age NE 15) then Group=1;

  B. where Age not between (15 and 16) then Group=1;

  C. where Age not between 15 and 16 then Group=1;

  D. if Age not in(15,16) then Group=1;

  Correct Answer: A

• Question 48:

  Given the following SAS data set WORK.SALES:

  

  The following SAS program is submitted:

  

  Which output is produced?

  

  A. B. C. D.

  Correct Answer: D

• Question 49:

  The SAS data set WORK STAFF has three variables:

  Name is character with a length of 8 DOB is numeric with a length of 8 Start_Date is numeric with a length of 8

  The following SAS program is submitted:

  

  What is the length of the Name variable in the data set WORK STAFF_UPDATE?

  A. 10

  B. 15

  C. 20

  D. 8

  Correct Answer: A

• Question 50:

  Population is currently at 34,278,400 for country A and is expected to rise at a rate of 2%.

  Which DO LOOP will correctly calculate growth rate over the next 10 years beginning in 2012 as shown in

  the graphic below?

  

  A. B. C. D.

  Correct Answer: B