I've got a variable called 'band', which has three values:
0-<2441
2449-<20001
200001-High
How can the 'band' variable be sorted (or resolve the error), as I'm running a proc surveyselect on my TEST dataset afterwards but have got the error message: "ERROR: Data set WORK.TEST is not sorted in ascending sequence. The current BY group has band=2449-<200001 and the next BY group has band=0-<2449"?
Current code:
proc sort data=test
out=final_checks;
by band;
run;