topic How to reset to original order of dataset after sorting? in SAS Data Management

How to reset to original order of dataset after sorting?

sri1 — Mon, 24 Feb 2020 12:09:26 GMT

I would like to know , how to get back to original order of a dataset after sorting by certain variable.

Your solutions are highly appreciated.

Thanks

PeterClemmensen — Mon, 24 Feb 2020 12:22:00 GMT

Why do you want to do that? Is this a general interest or an actual problem?

If your original order matters, you would create a sorted copy and word with that ..

nicobuettner — Mon, 24 Feb 2020 12:57:09 GMT

One solution might be to store the original order in a variable:

data x;
  set y;

  attrib n length=8;

  n = _N_;
run;

Then, later, after sorting:

proc sort data=x;
  by n;
run;