BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Dave25
Quartz | Level 8

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;

 
 
 

1 ACCEPTED SOLUTION

Accepted Solutions
JeffMeyers
Barite | Level 11
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.

View solution in original post

3 REPLIES 3
Dave25
Quartz | Level 8

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
Barite | Level 11
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
Quartz | Level 8
yep, forgot about type=discrete - thanks!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 3955 views
  • 0 likes
  • 2 in conversation