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 Jane Eslinger 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)

http://support.sas.com/resources/papers/proceedings17/SAS0235-2017.pdf

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 Options
• ODS EXCEL Statement Suboptions
• Placing multiple tables on multiple worksheets
• Creating a custom report

TOPIC 2) Highly Customized Graphs Using ODS Graphics (2:30 - 3:00)

https://www.pharmasug.org/proceedings/2016/DG/PharmaSUG-2016-DG07.pdf

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 Sets
• Drawing Spaces
• Dynamic Variables