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?

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

Evaluate responses using AI:

OFF

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

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;