Using the SAS LIBNAME to Process Excel Files - Exchanging Data Between SAS and Microsoft Excel - page 55

4.8 Overview of the Examples

4.8 List of Examples

Figure 4.8.1: List of Examples for Using LIBNAME Options.

Example Number General Description

4.1 Using the Engine Connection HEADER Option. This example

shows how the first row of an excel spreadsheet is treated when the
HEADER=NO option is used alone.

4.2 Using the Engine Connection MIXED Option. This example shows

how the MIXED=YES option can convert all of the data columns into
character values. But, be careful. This example takes advantage of the
HEADER=NO option, too. When all columns have a character value
in the first row, all columns will be character when read from the file.
Be ready to rename your variables.

4.3 Using the Engine Connection PATH Option. This example shows

two output Excel files being processed with a PATH= option to write
the spreadsheets.

4.4 Using the Engine Connection VERSION Option. The code in this

example shows how to write data to three different versions of Excel
output workbooks.

4.5 Using Named Literals with the LIBNAME Statement. The use of

Named Literals is explained in this example. These constants allow the
use of some special characters when reading or writing to an Excel
spreadsheet. The values are used to represent the sheet names and
allow some latitude when referencing Excel worksheets. The code first
writes a new worksheet into either a new or existing workbook. The
code then reads the same file into a SAS dataset.

4.6 Using PROC CONTENTS to Examine an Excel Workbook. The

code shown here produces a listing of the variables in the Excel
workbook. Both full worksheets and named ranges are displayed when
the output of the PROC CONTENTS is displayed.

4.7 Using Dataset Options to Process Date and Time Values. Dates and

time values are reformatted directly from Excel as the data is being
read into a SAS dataset. This can eliminate programming effort and
computer time to process date fields. But, always look to see how the
data is stored if you need the converted data values.

4.8 Using Dataset Options to Process Date Variable Type

Conversions. The DBSASTYPE option will allow you to convert an
Excel column of data values into SAS variables with specific formats.
This example converts two dates into variables with different formats.

Processing on 64-bit Operating Systems. This is an introduction to
the use of the PATH= option and the PCFILES engine as they relate to
32-bit and 64-bit software on a 64-bit computer.

4.9