Ch 2 - Accessing Data - Part 1

2.01 Which column names are valid? (Select all that apply)

• Month6

• 6month

• month#6

• month 6

• month_6

2.03 For the table storm_summary, which of the following values could properly be stored as a data value in the Basin column? (Check all that apply)

• East Pacific

• P

• EP

• east_pacific

• 12

Discussion: What challenges might arise if you use a fixed path in your program?

1. In this PROC CONTENTS output, what is the default length of the Birth_Date column?

• 4 bytes

• 8 bytes

• 32,767 bytes

• It does not have a default length.

2. Which LIBNAME statement has the correct syntax?

• libname reports "filepath/workshop";

• libname orion filepath/workshop;

• libname 3456a "filepath/workshop";

3. Which of the following tables is available at the beginning of a new SAS session?

• sales

• work.newsalesemps

• sashelp.class

4. In this table, what type of column is Employee_ID?

• character

• numeric

• temporary

• missing

5. Which of these statements about SAS dates are true? (Check all that apply)

• A SAS date is one of three of SAS column types: numeric, character, and date.

• SAS dates represent the number of days from January 1, 1960.

• SAS date values can be positive or negative.

• SAS date values can be used in calculations.

6. Which LIBNAME statement has the correct syntax for reading a Microsoft Excel file?

• libname excel "filepath/myexcelfile";

• libname mydata xlsx "filepath/myexcelfile";

• libname mydata xlsx "filepath/field_data.xlsx";

7. Which library name (libref) is valid?

• 2010Car

• car/2010

• car2010

• cars_2010