This is an archived event!

Some of the information on this page like registration links or contact information might be out of date.


SAS Workshop: Learn Smarter and Faster Ways to Create First-Rate Excel Reports

March 28, 2018 : 1:30pm - 3:00pm at Soto I, Room 115/116

The upcoming SAS Workshop Spring 2018 will be co-hosted by USC SAS iHUG and SC CTSI. Please join us for SAS giveaways and a chance to win a free SAS book. Coffee, fruit, and pastries will be provided.

Soto I, Room 115/116

Event Details

The upcoming SAS Workshop Spring 2018 will be co-hosted by USC SAS iHUG and SC CTSI. Please join us for SAS giveaways and a chance to win a free SAS book. Coffee, fruit, and pastries will be provided. The workshop speaker is <a href="" target="_blank" rel="noreferrer noopener">Jane Eslinger</a> from the SAS Institute. TOPIC 1) The REPORT Procedure and ODS Destination for Microsoft Excel: The Smarter, Faster Way to Create First-Rate Excel Reports (1:30 - 2:30) <a href=";d=DwMGaQ&amp;c=clK7kQUTWtAVEOVIgvi0NU5BOUHhpN0H8p7CSfnc_gI&amp;r=DctSanmAbl4DPZ2Kc0RoOg&amp;m=AM_ULxSN40mj3y17-q8NLY0Wpbv4zVCMDOfBqnyZkJQ&amp;s=ykfIXipRCM4y9ZTSri-LlgqU1M5X_n5_ucDwnguk6yI&amp;e="></a> ABSTRACT 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. Presentation Outline: ODS EXCEL Statement OptionsODS EXCEL Statement SuboptionsPlacing multiple tables on multiple worksheetsCreating a custom reportTOPIC 2) Highly Customized Graphs Using ODS Graphics (2:30 - 3:00) <a href=""></a> ABSTRACT You can use annotation, modify templates, and change dynamic variables to customize graphs in SAS® software. Standard graph customization methods include template modification (which most people use to modify graphs that analytical procedures produce) and SG annotation (which most people use to modify graphs that procedures such as PROC SGPLOT produce). However, you can also use SG annotation to modify graphs that analytical procedures produce. You begin by using an analytical procedure, ODS Graphics, and the ODS OUTPUT statement to capture the data that go into the graph. You use the ODS document to capture the values that the procedure sets for the dynamic variables, which control many of the details of how the graph is created. You can modify the values of the dynamic variables, and you can modify graph and style templates. Then you can use PROC SGRENDER along with the ODS output data set, the captured or modified dynamic variables, the modified templates, and SG annotation to create highly customized graphs. This paper shows you how and provides examples that use the LIFETEST and GLMSELECT procedures. Presentation Outline: Annotation Data SetsDrawing SpacesDynamic Variables

Contact Information

For questions, email&nbsp;Melissa Koc at&nbsp;<a href="" target="_blank"></a>

NIH Funding Acknowledgment: Important - All publications resulting from the utilization of SC CTSI resources are required to credit the SC CTSI grant by including the NIH funding acknowledgment and must comply with the NIH Public Access Policy.