topic Re: Exporting Proc Tabulate in Image in Graphics Programming

Exporting Proc Tabulate in Image

prashantgupta — Tue, 27 Mar 2018 07:41:25 GMT

HI,

I am attempting to export proc tabulate in image.

But it is not printing whole table it is printing half of the table with written "continued" at the bottom of the image.

How to export complete table in image.

Any help will be appreciated.

Re: Exporting Proc Tabulate in Image

hulksmash — Tue, 27 Mar 2018 13:26:35 GMT

Hello,

Are you trying to export it to PDF? Excel? HTML? PNG? Depending on that will depend on how you can accomplish your task.

Re: Exporting Proc Tabulate in Image

prashantgupta — Tue, 27 Mar 2018 13:29:22 GMT

Hi,
As I have already mentioned I am trying to export in Image. It can be any format - png or jpg.

Re: Exporting Proc Tabulate in Image

hulksmash — Tue, 27 Mar 2018 14:01:54 GMT

I would look into using the "ods printer" statement. A good example related to your issues can be found here: https://communities.sas.com/t5/SAS-GRAPH-and-ODS-Graphics/table-to-a-PNG-file/td-p/91867

I would mess with the ods options either setting the (paper) size or the pixels to make sure it saves as a single picture.

Re: Exporting Proc Tabulate in Image

ballardw — Tue, 27 Mar 2018 14:40:54 GMT

Since tabulate shows that "continued" note pretty much only with LISTING output which is a text destination I doubt if you can get an image directly from SAS.

You could send the output to another destination such as ODS PDF or ODS RTF and take a screen shot or possibly generate a png file from that output.

Re: Exporting Proc Tabulate in Image

GraphGuy — Thu, 29 Mar 2018 14:47:29 GMT

Not sure exactly what coding technique you're using, but here's an example where I save some Proc Report output as an image (which I then annotate on a graph). Perhaps you could try similar code with your Proc Tabulate, and see if it gets it all on one page:

http://robslink.com/SAS/democd56/table_image_info.htm