sgplot - order yaxis

[Dave25]

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;

[Dave25]

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;

[JeffMeyers · Accepted solution]

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.

[Dave25]

yep, forgot about type=discrete - thanks!