SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition

LIBNAME Statement Options

There are several options that you can use with the LIBNAME statement to control how SAS interacts with the Excel data. The general form of the SAS/ACCESS LIBNAME statement (with options) is as follows:

libname libref 'location-of-Excel-workbook' <options>;

Example:

libname doctors 'c:\clinicNotes\addresses.xlsx' mixed=yes;

DBMAX_TEXT=n

indicates the length of the longest character string where n is any integer between 256 and 32,767 inclusive. Any character string with a length greater than this value is truncated. The default is 1024.

GETNAMES=YES|NO

determines whether SAS will use the first row of data in an Excel worksheet or range as column names.

YES specifies to use the first row of data in an Excel ...