topic Re: sgplot - order yaxis in Graphics Programming

sgplot - order yaxis

Dave25 — Sun, 21 Apr 2019 01:58:05 GMT

completely flummoxed (guessing it's something really simple) - why doesn't this order by the data?

data test;
input id value;
cards;
id value
1 8.8
2 24
3 15
4 7.0
5 15.7
;
run;
proc sort data=test; by id; run;

/*tried this, doesn't change order: proc sort data=test; by descending id; run; */
proc sgplot data= test;
scatter y=id x=value ;
yaxis discreteorder=data;
run;

Re: sgplot - order yaxis

Dave25 — Sun, 21 Apr 2019 02:10:58 GMT

mis-copied my data (shouldn't have included "id value" after the cards statement)

data test;

input id value;
cards;

1 8.8
2 24
3 15
4 7.0
5 15.7
;
run

proc sgplot data= test;
scatter y=id x=value ;
yaxis discreteorder=data integer;
run;

Re: sgplot - order yaxis

JeffMeyers — Sun, 21 Apr 2019 02:14:34 GMT

Are both variables numeric? It probably has a linear y axis so the discrete order option would do nothing. Try adding type=discrete to the yaxis statement.

Re: sgplot - order yaxis

Dave25 — Sun, 21 Apr 2019 02:19:43 GMT

yep, forgot about type=discrete - thanks!