topic Reproducible Research in SAS in ODS and Base Reporting

Reproducible Research in SAS

mduarte — Mon, 15 Feb 2016 05:22:38 GMT

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.

Re: Reproducible Research in SAS

Reeza — Mon, 15 Feb 2016 06:26:50 GMT

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/FareezaKhurshed-CoordinateComplexReports-Spring2014.pdf

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

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

Re: Reproducible Research in SAS

Reeza — Mon, 15 Feb 2016 06:26:51 GMT

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.

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/FareezaKhurshed-CoordinateComplexReports-Spring2014.pdf

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

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

Re: Reproducible Research in SAS

ChrisHemedinger — Mon, 15 Feb 2016 14:07:00 GMT

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

Re: Reproducible Research in SAS

mduarte — Thu, 25 Feb 2016 04:07:51 GMT

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