proc sort ascending error

Justin9 — Fri, 01 Jul 2022 17:02:38 GMT

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;

Re: proc sort ascending error

sbxkoenk — Fri, 01 Jul 2022 17:08:53 GMT

Hello,

Are you sure you use FINAL_CHECKS as input to your PROC SURVEYSELECT?

I think you are using TEST instead!

Koen

topic Re: proc sort ascending error in SAS Programming

proc sort ascending error

Re: proc sort ascending error