BookmarkSubscribeRSS Feed
sri1
Obsidian | Level 7

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

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

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
SAS Employee

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;

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1297 views
  • 1 like
  • 3 in conversation