Exporting SAS Data sets and creating ODS files for ...

EXPORTING SAS? DATA SETS AND CREATING

ODS FILES FOR MICROSOFT EXCEL

GEORGIOS KARAGIANNIS, SAS SUPPORT

C op yr i g h t ? 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .

OUTPUT DELIVERY SYSTEM

?

You can use ODS statements to send output from procedures to a variety

of destinations.

PROC Step

EXCEL

HTML

RTF

XML

PDF

C op yr i g h t ? 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .

CSV

OVERVIEW OF METHODS

The following methods enable you to create a file that can be opened with

Excel or other software products:

Data Set Methods

?

EXPORT procedure

? SAS LIBNAME Engine for Excel

Procedure Output Methods via ODS

?

CSV and CSVALL

? MSOFFICE2K and MSOFFICE2K_X

? TABLEEDITOR

? EXCELXP

C op yr i g h t ? 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .

WHAT DO YOU WANT TO EXPORT?

Exporting��

Technique

SAS Data Set

EXPORT Procedure

Excel LIBNAME Engine

SAS Procedure Output

Output Delivery System

4

C op yr i g h t ? 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .

EXPORTING PROCEDURE OUTPUT VIA ODS

Destination

Type of File Created

CSV and CSVALL

CSV

MSOFFICE2K

HTML

MSOFFICE2K_X

HTML

TABLEEDITOR

HTML

EXCELXP

XML

5

C op yr i g h t ? 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download