Data visualization with SAS programming

Proc sgplot/Tickvalueformat problem

Accepted Solution Solved
Reply
Contributor
Posts: 45
Accepted Solution

Proc sgplot/Tickvalueformat problem

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;


Accepted Solutions
Solution
‎07-31-2015 01:10 PM
SAS Super FREQ
Posts: 864

Re: Proc sgplot/Tickvalueformat problem

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;

View solution in original post


All Replies
Solution
‎07-31-2015 01:10 PM
SAS Super FREQ
Posts: 864

Re: Proc sgplot/Tickvalueformat problem

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;

Contributor
Posts: 45

Re: Proc sgplot/Tickvalueformat problem

Thank you so much!

Post a Question
Discussion Stats
  • 2 replies
  • 584 views
  • 0 likes
  • 2 in conversation