topic Plot table and graph in Graphics Programming

Plot table and graph

michokwu — Tue, 10 Mar 2020 15:13:01 GMT

Hi experts,

I made a simple line graph using proc sgplot; however, I believe that combining the summary statistics table generated using the proc means command in the same plot may be more intuitive.Can anyone help with this. Attached: graph and table

Thank you,

Re: Plot table and graph

ballardw — Tue, 10 Mar 2020 16:20:31 GMT

More helpful would be including the code you used to create the Proc Means output, the SGPLOT code and example data. Data is best provided as data step code to allow everyone to see the properties of variables and so we can run code against the created data.

Depending on the actual data set used for plotting you likely want an XAXISTABLE statement, if plotting the summarized data.

Otherwise you may want an annotate data set of the summarized values (likely more complex).

Re: Plot table and graph

DanH_sas — Tue, 10 Mar 2020 17:51:26 GMT

Use an XAXISTABLE. Here is a simulation of how your code probably looks, and how you would use the XAXISTABLE. I put the variable on one statement, but you can put them on multiple statements if you want different visual attributes for each variable.

proc summary data=sashelp.class nway;
class age;
var weight;
output out=sumdata mean=mean median=median n=n;
run;

proc sgplot data=sumdata;
xaxis type=discrete;
series x=age y=n;
xaxistable n mean median;
run;

Hope this helps!

Dan

Re: Plot table and graph

michokwu — Tue, 10 Mar 2020 21:11:47 GMT

Thanks for the feedback, due to network issues I was unable to access the application and retrieve the info you required

Re: Plot table and graph

michokwu — Tue, 10 Mar 2020 21:12:16 GMT

It works. Thank you!