Proc sgplot/Tickvalueformat problem

[Greek]

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;

[DanH_sas · Accepted solution]

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;

[Greek]

Thank you so much!