topic How to output Proc report results to R in SAS Programming

How to output Proc report results to R

AnnaHawgood — Wed, 18 Nov 2020 12:17:43 GMT

Is there a way of outputting Proc report results to R?

I am creating a report, where I want to combine tables created in SAS (Proc report) with graphs created in R.

So far I have tried outputting my tables to png-files and importing them in R, but I'm having problems with the size and resolution. I know that there must be a way of improving the size and resolution, but if there is a way of creating a R source file (equivalent to the Latex-example here: https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-print-a-SAS-table-as-an-image-gif-jpeg-png/td-p/30525) I think it would work better for me.

Thanks!

Anna

JosvanderVelden — Wed, 18 Nov 2020 15:08:47 GMT

Have you seen this document "Streamline Your Workflow: Integrating SAS, LATEX, and R into a Single Reproducible Document by Lucy D’Agostino McGowan, Vanderbilt University"?
https://support.sas.com/resources/papers/proceedings17/0876-2017.pdf

AnnaHawgood — Thu, 19 Nov 2020 11:08:05 GMT

I hadn't seen it - thanks!

I'll give it a read-through and see if I can make it work for me.

- Anna