The SAS Output Delivery System and reporting techniques

Reproducible Research in SAS

Reply
Contributor
Posts: 73

Reproducible Research in SAS

Hi - I have been using R for many years and have been especially happy with the ability to create reports or presentations using the Knitr package within RStudio without having to copy and paste code or results.  I have read about SASweave and StatRep but they don't seem on-par with R/RStudio as, from what I understand, one cannot debug the code from within Latex.  Another solution seems to be use SAS within RStudio - but given I already know R I cannot see that benefit.

 

Are users out there able to provide me with their workflows to incorporate SAS output in written reports and presentations, so any changes to the data or processing are automatically reflected in the reports and presentations? (I try to avoid copy and paste wherever I can ...)

 

* Is it at least possible to dynamically link charts to Microsoft Word / Powerpoint? and are there references on how best to do this?

* Is a solution to save the charts as .PNG and include in Latex?  (although this wouldn't allow me to display variable values / results in text..)

 

Note that I am using SAS Enterprise Guide. 

 

Thanks.

 

Grand Advisor
Posts: 16,366

Re: Reproducible Research in SAS

SAS generates Powerpoints/PDF/RTF automatically.

 

Typically for my analysis, I'll generate the tables directly to RTF/Word files or PDF files as required.

You can search on lexjansen.com for sample code for reports/tables but the truth is there's so many different ways and SAS provides a ton of flexibility in incorporating your results into final products that I'm not even sure where to start.

 

I presented a paper a few years back on generating complex reports from SAS - it doesn't quite stand alone though:

http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Edmonton-User-Group/FareezaKhu...

 

The reports are here, 132 reports with customized text, graphs, maps, etc.

http://www.health.alberta.ca/services/PHC-community-profiles.html

Contributor
Posts: 73

Re: Reproducible Research in SAS

Thanks Reeza, those reports look great. I will create some sample reports using your method and the StatRep method that @ChrisHemedinger has suggested.
Grand Advisor
Posts: 16,366

Re: Reproducible Research in SAS

SAS generates Powerpoints/PDF/RTF automatically.

 

Typically for my analysis, I'll generate the tables directly to RTF/Word files or PDF files as required.

You can search on lexjansen.com for sample code for reports/tables but the truth is there's so many different ways and SAS provides a ton of flexibility in incorporating your results into final products that I'm not even sure where to start.

 

I presented a paper a few years back on generating complex reports from SAS - it doesn't quite stand alone though:

http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Edmonton-User-Group/FareezaKhu...

 

The reports are here, 132 reports with customized text, graphs, maps, etc.

http://www.health.alberta.ca/services/PHC-community-profiles.html

Community Manager
Posts: 2,605

Re: Reproducible Research in SAS

[ Edited ]

This is the sort of thing that StatRep was designed for.  I don't know about the limitations re: debugging that you mention, but I'll bet that SAS' @TimArnold could answer if you have specific concerns.

 

Some StatRep resources:

If using with SAS Enterprise Guide, I think it should work fine.  But you will probably need to adjust the application options to suppress the default ODS destinations, and take control to use the LaTex package.


Chris

Post a Question
Discussion Stats
  • 4 replies
  • 428 views
  • 2 likes
  • 3 in conversation