topic Re: Charting time data in Graphics Programming

Charting time data

sarahsasuser — Tue, 26 Mar 2013 21:42:23 GMT

I would like to create a horizontal bar chart that charts time in days. The x-axis would be total days. The bars would be the sum of 4 different times or phases, and color coded by phase. For example, building S3677 below would have a bar totaling 215 days, with each phase color coded within that bar.

The data is formatted like this:

Building phase1 phase2 phase3 phase4

S212 201 165 35 46

O254 198 144 120 58

S3677 100 25 36 54

Any suggestions?

Thanks.

Re: Charting time data

DanH_sas — Tue, 26 Mar 2013 22:08:35 GMT

First, transpose you data so that it looks like this:

Building Value Phase

S212 201 Phase1

S212 165 Phase2

S212 35 Phase3

S212 46 Phase4

...and so on.

Then, run either PROC SGPLOT or PROC GCHART:

proc sgplot data=buildings;

vbar building / response=value group=phase;

run;

proc gchart data=buildings;

vbar building / sumvar=value subgroup=phase;

run;

quit;

Hope this helps!

Dan

Re: Charting time data

sarahsasuser — Wed, 27 Mar 2013 13:42:13 GMT

Thanks Dan. Your answer made me realize that I need help with proc transpose more than the plotting procedures. I do not get the dataset I want when I do proc transpose data=have out=want; id building; var _all_; run;

Can you suggest a better way to transpose than I have?

Re: Charting time data

PGStats — Wed, 27 Mar 2013 14:00:12 GMT

This should do the trick

proc transpose data=have out=want(rename=(col1=value)) name=phase;

by building notsorted;

var phase: ;

run;

Re: Charting time data

sarahsasuser — Wed, 27 Mar 2013 14:37:07 GMT

Thanks PGStats!