topic Re: sgpanel vbar graph with tabular data in Graphics Programming

sgpanel vbar graph with tabular data

AmitKB — Thu, 01 Oct 2009 22:39:31 GMT

Hi all,
I want to create a sgpanel vbar graph by region, where the sas dataset is in following format. I dont know how to assign the response in the vbar.

Region qtr1 qtr2 qtr3 qtr4 <-- variable names
East 20 10 30 40
West 10 40 30 10
North 50 20 60 30
South 30 10 20 60

Thanks for all your help.

Regards,

Amit

Re: sgpanel vbar graph with tabular data

DanH_sas — Fri, 02 Oct 2009 01:51:05 GMT

You just need to transpose your data. Here's a simple example using your posted data:

data test;
input region $ qtr1 qtr2 qtr3 qtr4;
cards;
East 20 10 30 40
West 10 40 30 10
North 50 20 60 30
South 30 10 20 60
;
run;

proc transpose data=test out=transposed;
by region notsorted;
var qtr1 qtr2 qtr3 qtr4;
run;

proc sgpanel data=transposed;
panelby region;
vbar _name_ / response=col1;
run;

Re: sgpanel vbar graph with tabular data

AmitKB — Fri, 02 Oct 2009 16:16:42 GMT

Hi Dan,
Thanks for the solution. Its works great.

I appreciate all your help.

Regards,

Amit