Does your job require you to create reports in Microsoft Excel on a quarterly, monthly, or even weekly basis? Are you creating all or part of these reports by hand, referencing another sheet containing rows and rows and rows of data? If so, stop! There is a better way! 

The new ODS destination for Excel enables you to create native Excel files (XLSX) directly from SAS. Now you can include just the data you need, create great-looking tabular output, and do it all in a fraction of the time! 

This paper shows you how to use PROC REPORT to create polished tables that contain formulas, colored cells, and other customized formatting. Also presented in the paper are the destination options used to create various workbook structures, such as multiple tables per worksheet. Using these techniques to automate the creation of your Excel reports will save you hours of time and frustration, enabling you to pursue other endeavors.

Bio:

Jane Eslinger is an independent programmer based in North Carolina with over 20 years of experience with SAS.

Jane has authored two books: The SAS® Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques and The SAS® Programmer's PROC REPORT Handbook: ODS Companion. Her SAS certifications include Advanced Programmer for SAS®9, SAS® Certified Data Scientist, and SAS® Certified Advanced Visual Business Analyst.

She has presented at numerous conferences and users’ groups across the US, including SAS Global Forum from 2015 to 2020. Jane has served as a statistician and statistical programmer in the social science and clinical research fields. She earned her BS in Statistics from NC State University.