Stalk bar chart in controlled order in SAS -
i want create stlak bar charts, column workscope having hsb,ohs,res. want reorder workscope in order of ohs,hsb,res in stalk bar. default taking in alphabetical order. how can achieve it.
goptions reset=all; goptions colors=(red blue green); legend1 label=none order=('ohs' 'hsb' 'res'); proc gchart data=finalrepv3; vbar year / discrete type=sum sumvar=value subgroup=workscope legend=legend1 ; run;
you can create sorting variable beforehand, use sort input data , plot using proc sgplot
xaxis discreteorder = data
.
/* create dummy sorting variable */ data want; set finalrepv3; if workscope = "ohs" _sort = 1; if workscope = "hbs" _sort = 2; if workscope = "res" _sort = 3; run; /* put data in required order */ proc sort data = want; _sort; run; /* create plot */ proc sgplot data = want; vbar year / group = workscope response = value stat = sum; /* request x axis respect data's order */ xaxis discreteorder = data; run;
Comments
Post a Comment