Working with SAS® and Microsoft Excel
SASXL : PGXLM7
This course presents techniques for integrating SAS and Microsoft Excel to access Excel workbooks to explore, prepare, analyze, and report on your data using the SAS XLSX engine. You learn a bit about the history of SAS and Excel, and then how to easily read data from and write data to Excel files from 2007 and later using SAS techniques like the IMPORT and EXPORT procedures, and the LIBNAME engine. The course also teaches you to use the SAS Output Delivery System (or ODS) to create Excel reports. ODS enables you to customize your Excel reports by adding tables, summarized data, and visualizations using SAS. ODS also enables you to fully customize the styling of your Excel reports. Lastly, you learn about a few advanced techniques to add Excel formats and functions to Excel reports.
Learn How To
- Use the IMPORT procedure to create SAS tables from Microsoft Excel files.
- Use the EXPORT procedure to create Microsoft Excel files from SAS tables.
- Use the LIBNAME engine to create a library reference to an Excel workbook to easily read from and write to Excel.
- Use the SAS Output Delivery System (ODS) to create Microsoft Excel reports using SAS procedure output.
Who Should Attend
SAS programmers
Prerequisites
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:
This course addresses:
- Base SAS software 9.4M2 and later (including SAS Viya).
- SAS/ACCESS Interface to PC Files XLSX engine for Microsoft Excel 2007 and later.
- Output Delivery System (ODS) to produce Microsoft Excel files compatible with Microsoft Office 2010 and later.
SAS Products Covered
Base SAS
Course Outline
Importing and Exporting in Microsoft Excel Data
- Introduction to SAS and Microsoft Excel.
- Importing and exporting Excel data using procedures.
- Importing and exporting data using the LIBNAME engine.
- Introduction to the Output Delivery System (ODS).
- Creating Excel reports.
- Styling and formatting Excel reports.
Live Class Schedule
Duration: 7 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.