Desktop productivity for business analysts and programmers

SAS Data Sets records deleted.. Is there any way to recover.

Reply
Occasional Contributor
Posts: 15

SAS Data Sets records deleted.. Is there any way to recover.

I have mistakenly executed one data step that updated one of the permanent tables. Can anybody tell me is there any way to restore the data sets with the earlier version??

I will highly appreciate if anybody comesback with a quick and fast solution..

Super User
Posts: 5,386

Re: SAS Data Sets records deleted.. Is there any way to recover.

Assuming that you can't programmatically restore the tables to it's previous state, there are just a few thing that can help you:

  • File system restore, contact the responsible personnel for backups.
  • The Base SAS table is stored as generations, see documentation how to rollback to an earlier version.
  • The table is under audit trail. You can you programming to extract the changes from the trail and update the table accordingly.
Data never sleeps
Regular Contributor
Posts: 220

Re: SAS Data Sets records deleted.. Is there any way to recover.

I guess IT support always has physical backup for all your server drive (D:\, E:\ whatever) and retention for daily physical content also should be there. you can use their help...


Respected Advisor
Posts: 3,788

Re: SAS Data Sets records deleted.. Is there any way to recover.

In future you may want to add ACCESS=READONLY to your libname statements.

Or you can add ALTER or WRITE passwords to the data set you don't want to change.

Ask a Question
Discussion stats
  • 3 replies
  • 2654 views
  • 0 likes
  • 4 in conversation