The REPORT Procedure and ODS Destination for Microsoft Excel: The Smarter, Faster Way to Create First-Rate Excel Reports - Jane Eslinger, SAS
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.
Click here to download the companion paper.
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.
Click here to download the companion paper.
ODS Layout and the ODS Destination for PowerPoint - Jane Eslinger, SAS
Like a good pitcher and catcher in baseball, ODS layout and the ODS destination for PowerPoint are a winning combination in SAS® 9.4. With this dynamic duo, you can go straight from performing data analysis to creating a quality presentation. The ODS destination for PowerPoint produces native PowerPoint files from your output. When you pair it with ODS layout, you are able to dynamically place your output on each slide.
Through code examples this paper shows you how to create a custom title slide, as well as place the desired number of graphs and tables on each slide. Don't be relegated to the sidelines—increase your winning percentage by learning how ODS layout works with the ODS destination for PowerPoint.
Click here to download the companion paper.
Through code examples this paper shows you how to create a custom title slide, as well as place the desired number of graphs and tables on each slide. Don't be relegated to the sidelines—increase your winning percentage by learning how ODS layout works with the ODS destination for PowerPoint.
Click here to download the companion paper.
|
About the Presenter
Jane Eslinger is a Senior Technical Support Analyst at SAS Headquarters in Cary, North Carolina. Jane enjoys supporting SAS customers in using ODS and Base SAS® procedures, with an emphasis on PROC REPORT. Her SAS certifications include Advanced Programmer for SAS®9, SAS® Certified Data Scientist, and SAS® Certified Advanced Visual Business Analyst. 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. She has presented at numerous conferences and users’ groups across the US, including SAS Global Forum from 2015 to 2018. Before joining SAS, Jane 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.
|
