topic Re: Creating Bar chart and table using different table source in SAS Programming

Creating Bar chart and table using different table source

Scooby3g — Wed, 10 Mar 2021 20:28:11 GMT

Hi, I want to create a bar graph with a table like the below. However, the data that I want to use is in another table. Would I be able to use the data from another table to display in the table section without merging it?

https://support.sas.com/kb/49/697.html

Re: Creating Bar chart and table using different table source

Reeza — Wed, 10 Mar 2021 21:17:49 GMT

Depends on the ultimate output expected. You could pipe the output to a single PDF, RTF or HTML file and that would be trivial.

Getting into a single PNG may be slightly harder.

What is your final expected output format? Is this for a single graph or does this need to be scaled/expanded somehow?

@Scooby3g wrote:

Hi, I want to create a bar graph with a table like the below. However, the data that I want to use is in another table. Would I be able to use the data from another table to display in the table section without merging it?

https://support.sas.com/kb/49/697.html

Re: Creating Bar chart and table using different table source

Scooby3g — Wed, 10 Mar 2021 21:57:01 GMT

Output would be PDF: graph on top and table at the bottom.
Is "layout" the only option to go about it?

Re: Creating Bar chart and table using different table source

Reeza — Thu, 11 Mar 2021 01:23:06 GMT

Then you wouldn’t need to actually control anything, just specify startpage=NO on the ODS PDF statement and ensure the sizes will fit on a single page.

Re: Creating Bar chart and table using different table source

Scooby3g — Thu, 11 Mar 2021 14:18:23 GMT

How would the code look like? Do a "proc sgplot" then do "proc report"? I also intend to have multiple graphs on the report but plan to use the same table below each as reference.

Re: Creating Bar chart and table using different table source

Reeza — Thu, 11 Mar 2021 16:37:23 GMT

Yes, exactly - try it!

You can also look at the XAXISTABLE instead, which may be significantly easier than GTL.
https://blogs.sas.com/content/graphicallyspeaking/2016/12/01/mixing-plots-different-classification/

Re: Creating Bar chart and table using different table source

Scooby3g — Thu, 11 Mar 2021 17:49:27 GMT

Thanks Reeza, but on review of XAXISTABLE it seems to be meant for data from the same time.

Doing a proc sgplot then follow by proc report doesnt seem to work as the table jumps to the next page.