Data visualization with SAS programming

Exporting Proc Tabulate in Image

Reply
Occasional Contributor
Posts: 16

Exporting Proc Tabulate in Image

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.

out4.png

Any help will be appreciated.

 

 

Occasional Contributor
Posts: 11

Re: Exporting Proc Tabulate in Image

Posted in reply to prashantgupta

Hello,

 

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

 

Occasional Contributor
Posts: 16

Re: Exporting Proc Tabulate in Image

Posted in reply to hulksmash
Hi,
As I have already mentioned I am trying to export in Image. It can be any format - png or jpg.
Occasional Contributor
Posts: 11

Re: Exporting Proc Tabulate in Image

Posted in reply to prashantgupta

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.

Super User
Posts: 13,084

Re: Exporting Proc Tabulate in Image

Posted in reply to prashantgupta

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.

SAS Employee
Posts: 1,031

Re: Exporting Proc Tabulate in Image

Posted in reply to prashantgupta

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

 

Ask a Question
Discussion stats
  • 5 replies
  • 117 views
  • 0 likes
  • 4 in conversation