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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using the redcap api for data import and export
- electronic filing guide for the quarterly wage and
- p6 professional importing and exporting guide
- sde 3 0 user manual and field workbook fema
- masslynx 4 1 interfacing guide
- exporting sas data sets and creating ods files for
- entering and importing data
- customs handling of import and export freight chief
- xcel excel basics
- r data import export
Related searches
- free data sets for research
- free data sets for students
- data sets for healthcare
- medical data sets for statistics projects
- available data sets for students
- simple data sets for statistics
- data sets for statistics class
- data sets for projects
- free data sets for excel
- healthcare data sets and standards
- sample data sets for students
- quantitative data sets for analysis