topic proc sgplot label y axis with another character variable in Graphics Programming

proc sgplot label y axis with another character variable

zimcom — Tue, 27 Apr 2021 18:06:11 GMT

Greetings!

proc sgplot data=example noautolegend;
styleattrs datasymbols=(circlefilled );
scatter x=b y=a ;
keylegend / location=outside position=NW across=1;
run;

For the above code, is it possible to label the y axis using variable "CAT" to make the y-axis more meaningful?

CAT	a	b
CAT1	1	2
CAT2	2	3
CAT3	3	5
CAT4	4	1
CAT5	5	6
CAT6	6	4

Re: proc sgplot label y axis with another character variable

ballardw — Tue, 27 Apr 2021 19:41:39 GMT

I might suggest simply trying y=cat as a first simple to test code.

When a character variable is used for a yaxis like that the first alphabetic value will be closest to the x axis and be in ascending alphabetical value from bottom to top.

If that isn't sufficient then I would use your A and Cat values to make a format then apply the format to the A variable in the plot.

proc format;
value AtoCat
1= 'Cat 1'
2= 'Cat 2'
<repeat as needed>
;

proc sgplot data=example noautolegend;
   styleattrs datasymbols=(circlefilled );
   scatter x=b y=a ;
   keylegend / location=outside position=NW across=1;
   format a AtoCat. ;
run;

If you have LOTS of A values you may need to use a YAXIS statement to make the axis TYPE=Discrete and set a FITPOLICY=none to force all the values to have a tick mark to label.

Re: proc sgplot label y axis with another character variable

Reeza — Tue, 27 Apr 2021 20:09:20 GMT

Does a scatter plot make sense for your data? Also

Either way, another option is to list the values on the XAXIS statement but the FORMAT is definitely the better answer.

proc sql noprint;
select quote(cat) into :labels_list separated by " " from example order by a;
select quote(a) into :values_list separated by " " from example order by a;
quit;

Then add this to your PROC SGPLOT.

XAXIS VALUES = (&values_list.) VALUESDISPLAY = (&labels_list.);

Re: proc sgplot label y axis with another character variable

zimcom — Tue, 27 Apr 2021 20:29:08 GMT

Thank you, it works!
The reasxon I cannot use trying y=cat, becasure there is correlation between the 2 variavles, as you pointed out the alphabetical order will screw the corelation.
But the 2nd solution works perfect!

Re: proc sgplot label y axis with another character variable

zimcom — Tue, 27 Apr 2021 20:30:07 GMT

Thanks @Reeza, you have been always so helpful too !!