One of our user accidentally overwrote the original dataset. Could anyone please tell me how to recover previous version of the dataset?
I appreciate the help.
Regards,
Paulina
Are you on Windows or Unix? SAS Server? If its windows and on a local drive and you have versioning set up, go to the parent folder, click properties, see previous versions - may have to a wait a few minutes for it to populate (literally a few minutes).
SAS Server is on Windows. Under Previous Versions it says "There are no previous versions available".
I see that Shadow Copies of Shared Folders to make Previous Versions available is not enabled and configured on the file server.
:'( then its bye bye unless you can get a backup copy from a nightly/weekly backup. That's usually time intensive/$$.
If this dataset was stored in a server folder, check with your IT folks regarding server backups, and whether you can get the dataset restored from backup. If this was stored on a PC then it is unlikely to be backed up anywhere and SAS does not do backups itself.
Dataset has been stored on server folder.
Hi,
One of our user accidentally overwrote the original dataset. Could anyone please tell me how to recover previous version of the dataset?
I appreciate the help.
Regards,
Paulina
@paulinalawson wrote:
Hi,
One of our user accidentally overwrote the original dataset. Could anyone please tell me how to recover previous version of the dataset?
I appreciate the help.
Regards,
Paulina
If you do not have a backup (after checking with your IT staff) then how was the data set created initially? If it was read from another data source did you keep that program and source file? If so, rerun that code (and any cleaning/modification step up do but not the code which destroyed.
Now, go back through all of your code and change all the instances of
Data olddataset;
set olddataset;
to something like
Data newerdataset;
set olddataset;
to prevent this.
And beat all the programmers/users that use that old/old syntax with wet spaghetti noodles until they promise to stop.
It might not hurt to bill the time/effort cost to the offending persons project budget as a lesson if possible.
@paulinalawson wrote:
Hi,
One of our user accidentally overwrote the original dataset. Could anyone please tell me how to recover previous version of the dataset?
I appreciate the help.
Regards,
Paulina
Very easy. Restore from your backup.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.