This course presents the most effective techniques for exporting SAS tables or procedure output from Base SAS into Excel spreadsheets. The course uses examples to show the basics of the SAS Excel LIBNAME engine, the EXPORT procedure, and ODS to create CSV, HTML, and XML files that can be opened by Excel.
Learn how to
- use the EXPORT procedure to create Microsoft Excel files from SAS tables
- use the LIBNAME engine to create Microsoft Excel files from SAS tables
- use ODS to create comma-separated-values files and HTML files for Microsoft Excel
- use ODS to create Spreadsheet Markup Language files for Microsoft Excel.
Who should attend
SAS programmers
Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS Programming 1: Essentials course and used SAS for at least one month. Basic knowledge of the Output Delivery System (ODS) and simple ODS invocation techniques is helpful, but not required.
This course addresses Base SAS software.
Introduction- course logistics
- course overview
- program review
Exporting SAS Data Sets- introduction to SAS/ACCESS Interface to PC Files
- using the EXPORT procedure li>using the Excel LIBNAME engine
Creating CSV Files- using CSV and CSVALL destinations
Creating HTML Files- using the MSOFFICE2K destination
- using the MSOFFICE2K_X destination
- passing Microsoft formats to Excel
Creating XML Files- defining Spreadsheet Markup Language
- using EXCELXP to create SpreadsheetML files
- customizing EXCELXP output
Comparing Methodologies
Learning More- SAS resources
- beyond this course
Self-Study Topic- using the TABLEEDITOR destination