Display X Axis Value in multiple lines using PROC SGPLOT in SAS9.2

[Wang_Yajun]

Hi,

As the subject indicates, my sas version is 9.2, so the fitpolicy option in the xaxis statment only have the following values: STAGGER,ROTATE,THIN and its combinations, without the split option.  Since my values for the axis is a little bit long , running the code below generates an ugly graph. I am wondering if there is any other possible way to display the values on the X axis in mutiline mode? Thanks!

proc sgplot data = Ind_stat; 
xaxis type = discrete label = "ind" fitpolicy = staggerrotate display = (noticks); 
yaxis label = "# of Customers";
vbar hy/response = n datalabel;
run; 

[Jay54]

There are not many options with SAS 9.2.  With SAS 9.3 you can use SGAnnotate to replace the tick values with split values.  With SAS 9.4, you can get split tick values from the procedure itself.

[Wang_Yajun]

Hi, Sanjay

Only SAS 9.2 is available in my working computer, I am wondering if there is other potential options, thanks !

[Jay54 · Accepted solution]

One way with SGPLOT would be to use the HBAR statement instead of VBAR.  Then, the long category labels are displayed on the Y axis.  Better than slanted labels on the x-axis.

Another way would be to use GCHART procedure, and use the SplitChar option as shown in this example:  http://support.sas.com/kb/45/123.html

[Jay54]

Which solution did you prefer?

[Wang_Yajun]

Hi, Sanjay

Using Hbar statement in SGPLOT looks a little bit better than VBar statement, but it still looks weird. PROC GCHART solves this problem prefectly in SAS 9.2, thanks for your input.