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
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.
Exporting SAS Data Sets
- course logistics
- course overview
- program review
Creating CSV Files
- introduction to SAS/ACCESS Interface to PC Files
- using the EXPORT procedure li>using the Excel LIBNAME engine
Creating HTML Files
- using CSV and CSVALL destinations
Creating XML Files
- using the MSOFFICE2K destination
- using the MSOFFICE2K_X destination
- passing Microsoft formats to Excel
- defining Spreadsheet Markup Language
- using EXCELXP to create SpreadsheetML files
- customizing EXCELXP output
- SAS resources
- beyond this course
- using the TABLEEDITOR destination