topic Re: How to create below figure via GTL? in Graphics Programming

How to create below figure via GTL?

Jack2012 — Fri, 26 Aug 2016 11:26:33 GMT

Please help me figure out how to create below figure via GTL, thanks.

Re: How to create below figure via GTL?

RW9 — Fri, 26 Aug 2016 12:02:47 GMT

It looks like a multi-panel bargraph to me. You will find examples on pretty much every graph over here including code:

http://blogs.sas.com/content/graphicallyspeaking/

For instance:

http://blogs.sas.com/content/graphicallyspeaking/?s=panel

Re: How to create below figure via GTL?

Reeza — Fri, 26 Aug 2016 13:09:06 GMT

What version of SAS?

Re: How to create below figure via GTL?

Cynthia_sas — Fri, 26 Aug 2016 13:23:40 GMT

Hi:
I'm not sure you need GTL, it looks like SGPANEL output to me. What code have you tried?
cynthia

Re: How to create below figure via GTL?

DanH_sas — Fri, 26 Aug 2016 15:06:48 GMT

If a may make a suggestion, try taking the variable you used for the panel row (agegroup ?) and make it the grouping variable for the bar chart. I think it would make your comparisons in the chart easier to read.

To accomplish this with PROC SGPANEL, you code will look something like this:

proc sgpanel data=outcome;

panelby sequence treatment / layout=lattice onpanel novarname;

vbar outcome / response=count group=agegroup groupdisplay=cluster; /* not sure of what stat you need */

run;

Hope this helps!

Dan

Re: How to create below figure via GTL?

Jack2012 — Fri, 26 Aug 2016 15:34:03 GMT

Thanks for your code. But I can only get below with each cell contains two formulation results. I know this is due to we use the Lattice alyout. What I am seeking is is there possibility to add two levels in the header and with each row for one age group? Just like my sample figure in the first post.

Thanks.

Re: How to create below figure via GTL?

DanH_sas — Fri, 26 Aug 2016 15:56:35 GMT

Unfortunately, we do not have support for multi-header layouts at this time. However, your age group variable fall into a natural cluster grouping scenario. Have you tried putting "agegroup" as the group variable and "drug description" on the lattice?

Thanks!
Dan

Re: How to create below figure via GTL?

Jack2012 — Fri, 26 Aug 2016 16:10:00 GMT

I have got your point. That is the one I am seeking.

I think I can try merge the two headers into one.

Best