SAS Data Analyst Academy / Session 2.a

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

• a. 4 bytes

• b. 8 bytes

• c. 32,767 bytes

• d. It does not have a default length

2. 2. Which LIBNAME statement has the correct syntax?

• a. libname reports "filepath/workshop";

• b. libname orion filepath/workshop;

• c. libname 3456a "filepath/workshop";

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

• a. sales

• b. work.newsalesemps

• c. sashelp.class

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

• a. character

• b. numeric

• c. temporary

• d. missing

5. 5. Which statement about SAS dates is false?

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

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

• c. SAS date values can be positive or negative.

• d. SAS date values can be used in calculations.

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

• a. libname excel "filepath/myexcelfile;

• b. libname mydata xlsx "filepath/myexcelfile;

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

7. 7. Which library name (libref) is valid?

• a. 2010Car

• b. car/2010

• c. car2010

• d. cars_2010

8. 8. To disassociate a libref that you previously assigned, you can use the UNASSIGN option in the LIBNAME statement.

• a. True

• b. False

9. 9. Which statement in a PROC MEANS step enables you to specify the numeric columns to analyze?

• a. TABLES

• b. VARS

• c. VAR

• d. KEEP=

10. 10. In which portion of a SAS table are the following found?

    -name of the table

    -type of the column Salary

    -creation date of the table

• a. descriptor version

• b. data portion