About akhan205

akhan205 · ‎06-28-2017

Thank you for the tranpose idea! This is what ultimately worked: proc transpose data=chart out=dataset; id year; run; %macro year (inp = ); %do i=2001 %to 2012; title "&inp. &i."; proc gchart data=dataset; where _name_ in ("&inp.var1","&inp.var2","&inp.var3"); vbar _name_ / sumvar = _&i.; run; %end; %mend year;

akhan205 · ‎06-27-2017

I am able to create many types of bar charts in SAS but the simplest is escaping my grasp. A subset of my data looks somewhat like this: Year Var1 Var2 Var3 2004 0.50 0.38 0.93 2005 0.40 0.22 0.88 I want to create (for each year) a simple bar chart that has 3 bars, one for each variable and along the same axis for its respective value, but it seems like I am able to plot everything except what I'm trying to accomplish. This is easily done in Excel but I am automating the process since I need to make many charts (I need no assistance with automation). I have tried using Year as one of the variables (after limiting my plotting to certain years using a where statement) but still to no avail. Any advice?

Online Status	Offline
Date Last Visited	‎06-28-2017 06:27 PM

Re: Simple bar chart (multiple variables)

Simple bar chart (multiple variables)

Re: Simple bar chart (multiple variables)

Re: Simple bar chart (multiple variables)

Simple bar chart (multiple variables)