topic Re: Display X Axis Value in multiple lines using PROC SGPLOT in SAS9.2 in Graphics Programming

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

Wang_Yajun — Wed, 15 Jun 2016 00:55:34 GMT

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;

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

Jay54 — Wed, 15 Jun 2016 03:23:05 GMT

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.

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

Wang_Yajun — Wed, 15 Jun 2016 04:43:46 GMT

Hi, Sanjay

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

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

Jay54 — Thu, 16 Jun 2016 18:08:07 GMT

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

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

Jay54 — Mon, 20 Jun 2016 13:23:04 GMT

Which solution did you prefer?

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

Wang_Yajun — Mon, 20 Jun 2016 13:36:10 GMT

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.