SAS P1 L3b

Question 1

Four characteristics of user-created library?

Answer 1

User-created library is:

1. Permanent
2. Implemented within operating system file system.
3. NOT automatically available in SAS session.
4. must assign libref to user created library to make it available in SAS session.

Question 2

How define library?

Syntax?

Answer 2

To define library, use LIBNAME to associated libref with physical location. Makes data available during current session.

Syntax: LIBNAME libref ‘SAS-library’

LIBNAME = key word

Question 3

Rules for libref names?
length?
begin with?
use?

Answer 3

Rules for libref names:

• length: 1 to 8 characters
• must begin with letter or underscore
• must use (contain) letters, underscore, or numbers

Question 4

Location for libref?

Answer 4

Libref location must reference an existing folder.
Enclose physical location in single or double quotes.

[LIBNAME doesn’t create new folder]

Question 5

What is LIBNAME?
type of statement?
need run?
need be with other?
how many can you have?

Answer 5

LIBNAME:
- is a GLOBAL statement
- does NOT need run statement
- can be submitted alone or store with other SAS programs
- can use more than one LIBNAME statement/program
(for different libraries)

Question 6

How do you browse library via a program?
Syntax?
Key words?

Answer 6

How to browse library via program:
PROC CONTENTS statement

PROC CONTENTS DATA=libref.ALL;
RUN;

this will display list of all SAS files in SAS library
Keywords: PROC, CONTENTS, ALL

Question 7

When browsing library, how omit descriptor portion?

Answer 7

Add “nods” to end of ALL

leave space after underscore

Question 8

What does CONTENTS produce? (3 things)

order?

Answer 8

CONTENTS produces (shows) the following:

1. directory
2. listing of members of library and member type (in alpha order )
3. information about each individual data set in library = descriptor portion

• if don’t need descriptor portion, use “nods”

Question 9

What does PROC PRINT do?

Syntax?

Answer 9

PROC PRINT
accesses permanent data set

PROC PRINT DATA=SAS-DATA-SET;
RUN;

Question 10

How cancel libref?

Syntax?

Answer 10

Must use CLEAR statement to cancel libref.
(will dissociate library)
Otherwise stays in effect until session ends.

LIBNAME libref CLEAR;