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

EXPORTING SAS? DATA SETS AND CREATING ODS FILES FOR MICROSOFT EXCEL

GEORGIOS KARAGIANNIS, SAS SUPPORT

Copyright ? 2014, SAS Institute Inc. All rights reserved.

OUTPUT DELIVERY SYSTEM

? You can use ODS statements to send output from procedures to a variety of destinations.

PROC Step

EXCEL

HTML

RTF

Copyright ? 2014, SAS Institute Inc. All rights reserved.

PDF

CSV

XML

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

Copyright ? 2014, SAS Institute Inc. All rights reserved.

WHAT DO YOU WANT TO EXPORT?

Exporting... SAS Data Set

SAS Procedure Output

Technique

EXPORT Procedure Excel LIBNAME Engine Output Delivery System

4

Copyright ? 2014, SAS Institute Inc. All rights reserved.

EXPORTING PROCEDURE OUTPUT VIA ODS

Destination CSV and CSVALL MSOFFICE2K MSOFFICE2K_X TABLEEDITOR EXCELXP

Type of File Created CSV HTML HTML HTML XML

5

Copyright ? 2014, SAS Institute Inc. All rights reserved.

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

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

Google Online Preview   Download