topic Re: Sort numeric sequentially in SAS Programming

Sort numeric sequentially

mandyosu01 — Tue, 27 Apr 2021 19:00:58 GMT

Hello,

I want to sort years in column sequentially. For example,

Data have

Data want

Thank you so much!

Astounding — Tue, 27 Apr 2021 18:50:48 GMT

You'll need to add a variable to indicate the proper order. For example:

data want;
   set have;
   by id year;
   if first.year then order=1;
   else order + 1;
run;

Then all you need to do is sort the data:

proc sort data=want;
   by id order year;
run;

Reeza — Tue, 27 Apr 2021 19:01:37 GMT

FYI - I edited your question to remove the spoiler under the assumption that it was erroneously added.