topic proc sort in SAS Programming

proc sort

kvpseshu — Mon, 20 May 2019 10:11:02 GMT

By mistake without using out statement i have modified existing data set, Is there any possibility for retrieving the previous data set

Re: proc sort

PeterClemmensen — Mon, 20 May 2019 10:16:57 GMT

No. PROC SORT Replaces the exitsting data set if you do not specify the OUT= Option.

Re: proc sort

Kurt_Bremser — Mon, 20 May 2019 10:49:17 GMT

@kvpseshu wrote:

By mistake without using out statement i have modified existing data set, Is there any possibility for retrieving the previous data set

Only from the last backup.

If you did not do anything that removes information (nodupkey, drop columns), and you know the previous sort order, you can re-sort it to that.