Good morning,
I am trying to figure out why isn't the option "tickvalueformat" working. I modified my code for your convenience by adding a step with datalines. It should run without you having to do anything. I get numbers 3-7 in the xaxis instead of the months March-July...
Does anybody know what's wrong?
data vbar;
length combined $30;
input month $ month_numeric combined $ Hours @@;
datalines;
March 3 compensation 148.9
March 3 projects 31.1
April 4 compensation 148.5
April 4 projects 36.5
May 5 compensation 114.9
May 5 projects 50.3
June 6 compensation 73.7
June 6 projects 113.4
July 7 compensation 102.3
July 7 projects 73.8
run;
proc format;
value monthly
3='March'
4='April'
5='May'
6='June'
7='July'
;
run;
proc sgplot data=vbar;
vbar month_numeric/response=hours group=combined groupdisplay=cluster;
xaxis tickvalueformat=monthly;
run;
Do it this way, and it will work for you:
proc sgplot data=vbar;
format month_numeric monthly.;
vbar month_numeric/response=hours group=combined groupdisplay=cluster;
run;
Do it this way, and it will work for you:
proc sgplot data=vbar;
format month_numeric monthly.;
vbar month_numeric/response=hours group=combined groupdisplay=cluster;
run;
Thank you so much!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.