topic Re: SGPLOT x-axis labels using a format in New SAS User

SGPLOT x-axis labels using a format

tmlee02 — Wed, 25 Nov 2020 03:13:41 GMT

Hello,

I'm having trouble getting the labels to appear on the X-axis. I already have a format in SAS for Var2. When I run the code below, there are no labels on the X-axis. I would like the x-axis to display the values of Var2 and tick marks at A, B, C, D, and E. I have tried running this with and without the FORMAT and VALUESFORMAT statements and it is the same outcome. Any tips would be appreciated! Thanks!

PROC SGPLOT DATA = newdata NOAUTOLEGEND;
FORMAT Var2 $Var2.;
VBOX Var1 /GROUP = Var2 ;

XAXIS VALUES = ("A" "B" "C" "D" "E")
VALUESFORMAT= $Var2.

YAXIS VALUES = ( 0 TO 100 BY 10 );
RUN;

Re: SGPLOT x-axis labels using a format

PGStats — Wed, 25 Nov 2020 04:13:32 GMT

Try using CATEGORY instead of GROUP:

PROC SGPLOT DATA = newdata NOAUTOLEGEND;
FORMAT Var2 $Var2.;
VBOX Var1 / CATEGORY = Var2 ;
XAXIS VALUES = ("A" "B" "C" "D" "E")
VALUESFORMAT= $Var2.;
YAXIS VALUES = ( 0 TO 100 BY 10 );
RUN;

Re: SGPLOT x-axis labels using a format

tmlee02 — Wed, 25 Nov 2020 20:01:16 GMT

Hi,

Thanks for your help. I put in CATEGORY and this did add the label to the x-axis. However, it only displays one of my categorical variables ("A") instead of displaying A, B, C, D, and E. Any thoughts on why that might be?

Thanks!

Re: SGPLOT x-axis labels using a format

ballardw — Wed, 25 Nov 2020 21:36:27 GMT

@tmlee02 wrote:

Hi,

Thanks for your help. I put in CATEGORY and this did add the label to the x-axis. However, it only displays one of my categorical variables ("A") instead of displaying A, B, C, D, and E. Any thoughts on why that might be?

Thanks!

Definition of your custom format?

Data values?

Interaction between the two.

Re: SGPLOT x-axis labels using a format

PGStats — Wed, 25 Nov 2020 22:54:50 GMT

Try removing the XAXIS statement altogether. Begin from a simpler starting point.