Base SAS to Microsoft Excel: Counting the Ways - SASXL
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.
|Download course description as PDF||Register now|
|½ day - Live Web Classroom|
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.
- introduction to course topics and concepts
Creating Microsoft Excel Files from SAS Tables
- using the EXPORT procedure
- using the external file interface (self-study)
- using the Excel LIBNAME Engine
Using ODS to Create Comma-Separated Value Files
- using ODS CSV and other CSV tagsets
Using ODS to Create HTML Files for Microsoft Excel
- creating HTML 3.2 and HTML 4.0 files
- creating Microsoft HTML files with the MSOFFICE2K tagset
- using CSS to change style and number formats (self-study)
Using ODS to Create XML Files for Microsoft Excel
- what is spreadsheet markup language?
- using ODS TAGSETS.EXCELXP to create SpreadsheetML files
- ExcelXP advanced topics
Other Methods of Creating Files for Microsoft Excel (Self-Study)
- additional file creation methods
This course addresses Base SAS software. This course is appropriate for students who are using SAS 9 software.