This workshop 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. You will 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, and use ODS to create Spreadsheet Markup Language files for Microsoft Excel. This is a hands-on workshop. This workshop is available to UC researchers only.
- This event has passed.
Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel
September 28, 2015 @ 9:00 am - 4:00 pm