Ch 3 - Expl & val data - part 2

3.02 Activity. Open p103a02.sas from the activities folder... Add a new WHERE statement to print storms that begin with Z. How many storms are included in the results?

(a)  

3.03 Activity (p103a03.sas). ... Which procedure did not produce a report? What is different about the WHERE statement in that step?

3.06 Activity (p103a06.sas), Q2. Which storm in the North Atlantic basin (NA or na) had the strongest MaxWindMPH?

(a)  

1. Which of the following is a valid name for a character format?

• country

• $ctry

• $country.

• _country

2. Which of the following FORMAT statements was used to create this output?

• format Order_Date date9. Delivery_Date mmddyy8.;

• format Order_Date date7. Delivery_Date mmddyy8.;

• format Order_Date ddmmmyy. Delivery_Date mmddyy8.;

• format Order_Date monyy7. Delivery_Date mmddyy8.;

3. A period must be included when applying a format using a FORMAT statement.

• True

• False

4. Which row or rows are selected by the following WHERE statement?

• row 1

• row 2

• row 3

• rows 1 & 2

• all three rows

5. Which statement about this PROC SORT step is true?

• Which statement about this PROC SORT step is true?

• The rows are sorted by Salary in descending order, and then by Manager_ID in descending order.

• A semicolon should not appear after the input table name.

• The sorted table contains only the columns specified in the BY statement.

6. Which of the following statements selects from a table only those rows where the value of the Style column is RANCH, SPLIT, or TWOSTORY?

• where Style='RANCH' or 'SPLIT' or 'TWOSTORY';

• where Style in 'RANCH' or 'SPLIT' or 'TWOSTORY';

• where Style in (RANCH, SPLIT, TWOSTORY);

• where Style in ('RANCH', 'SPLIT', 'TWOSTORY');

7. Which of the following statements selects rows in which Amount is less than or equal to $5,000 or Rate equals 0.095? (Check all that apply)

• where amount <= 5000 or rate=0.095;

• where amount le 5000 or rate=0.095;

• where amount <= 5000 or rate eq 0.095;