topic Re: SAS Data Sets records deleted.. Is there any way to recover. in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119283#M9988 <HTML><HEAD></HEAD><BODY><P>In future you may want to add ACCESS=READONLY to your libname statements.</P><P></P><P>Or you can add ALTER or WRITE passwords to the data set you don't want to change.</P></BODY></HTML> Wed, 09 Jan 2013 17:44:33 GMT data_null__ 2013-01-09T17:44:33Z SAS Data Sets records deleted.. Is there any way to recover. https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119280#M9985 <HTML><HEAD></HEAD><BODY><P>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??</P><P></P><P>I will highly appreciate if anybody comesback with a quick and fast solution..</P></BODY></HTML> Wed, 09 Jan 2013 08:00:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119280#M9985 arnab61 2013-01-09T08:00:20Z Re: SAS Data Sets records deleted.. Is there any way to recover. https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119281#M9986 <HTML><HEAD></HEAD><BODY><P>Assuming that you can't programmatically restore the tables to it's previous state, there are just a few thing that can help you:</P><UL><LI>File system restore, contact the responsible personnel for backups.</LI><LI>The Base SAS table is stored as generations, see documentation how to rollback to an earlier version.</LI><LI>The table is under audit trail. You can you programming to extract the changes from the trail and update the table accordingly.</LI></UL></BODY></HTML> Wed, 09 Jan 2013 09:01:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119281#M9986 LinusH 2013-01-09T09:01:34Z Re: SAS Data Sets records deleted.. Is there any way to recover. https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119282#M9987 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P><BR /> </P></BODY></HTML> Wed, 09 Jan 2013 16:48:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119282#M9987 sas_9 2013-01-09T16:48:38Z Re: SAS Data Sets records deleted.. Is there any way to recover. https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119283#M9988 <HTML><HEAD></HEAD><BODY><P>In future you may want to add ACCESS=READONLY to your libname statements.</P><P></P><P>Or you can add ALTER or WRITE passwords to the data set you don't want to change.</P></BODY></HTML> Wed, 09 Jan 2013 17:44:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/119283#M9988 data_null__ 2013-01-09T17:44:33Z Re: SAS Data Sets records deleted.. Is there any way to recover. https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/956310#M45726 <P>Yes there is. If you connect with R to SAS R has its own dataset reader interface what draws through the deleted records too and you can undelete them in R.</P><P>Another possible option what I have not tried for 25 years - so maybe it does not work anymore - is dBase. As far I remember, dBase export from SAS contained the deleted records too, and you could set them back to undeleted in dBase. There still exists dBase somewhere out there but I did not try it with this version.</P> Thu, 16 Jan 2025 14:12:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Data-Sets-records-deleted-Is-there-any-way-to-recover/m-p/956310#M45726 voroslaszlo 2025-01-16T14:12:07Z