topic Re: how can I restore the deleted datasets in SAS Programming

how can I restore the deleted datasets

Niugg2010 — Tue, 08 Nov 2016 16:25:43 GMT

If I delected a datasets by methods such as ;

proc sql;

drop table1;

quit;

proc datasets lib=abc;

delet data1;

run;

Where can I find the deleted datasets in my computer? Or how can I restore the deleted datasets?

Thanks

Re: how can I restore the deleted datasets

GreggB — Tue, 08 Nov 2016 16:29:02 GMT

Did you look in your Work library?

Re: how can I restore the deleted datasets

Niugg2010 — Tue, 08 Nov 2016 16:37:15 GMT

For example:

libname a "C:\*************";
data a.abc;
x=a;
y=b;
run;

proc sql;
drop table a.abc;
quit;

the datasets a.abc was completely delected from my computer.

How can I get a.abc back?

Re: how can I restore the deleted datasets

Reeza — Tue, 08 Nov 2016 16:38:13 GMT

@Niugg2010 wrote:

For example:

the datasets a.abc was completely delected from my computer.

Yes, that's what DROP does.

Did you accidentally delete a table you need? I'm not sure what you're trying to do here.

Are are you on Windows or Unix?

Re: how can I restore the deleted datasets

Niugg2010 — Tue, 08 Nov 2016 16:39:44 GMT

Yes. I am using windows.

Re: how can I restore the deleted datasets

Reeza — Tue, 08 Nov 2016 17:08:25 GMT

Depending on timing and your set up this may or may not work.

Navigate to library path in Windows.

If Windows 7, right click (on folder) and select properties. In properties pane look for the tab previous versions. Click it. WAIT. It takes a few minutes to populate if it's been turned on. Then you can navigate back in time and restore your file.

In Windows 10 (I have no experience) ) here are the instructions from MSFT

https://support.microsoft.com/en-ca/help/17143/windows-10-back-up-your-files

Be careful what you delete.

Re: how can I restore the deleted datasets

Shmuel — Tue, 08 Nov 2016 17:13:58 GMT

As much as I know, deleteing a dataset by SAS procedures, deletes it from the disk

without moving the dataset to the trash. Unless you have backed it up,

the only way is to recreate it, assuming you have the inputs and there are no random created variables.

I think that even a disk recovery tool will not help, as probably the file will be read by sas as damaged.

Re: how can I restore the deleted datasets

Niugg2010 — Tue, 08 Nov 2016 17:17:24 GMT

Thanks. I thought afte delet/drop it will move to a temperary fold, like to "recycle bin".

Re: how can I restore the deleted datasets

Niugg2010 — Tue, 08 Nov 2016 17:20:06 GMT

Thanks. So the safe way is to build a copy in WORK library and then deal with it.

Re: how can I restore the deleted datasets

Reeza — Tue, 08 Nov 2016 19:29:42 GMT

@Niugg2010 wrote:

Thanks. So the safe way is to build a copy in WORK library and then deal with it.

That depends. You haven't actually explained what you're trying to do.

Re: how can I restore the deleted datasets

Niugg2010 — Tue, 08 Nov 2016 19:34:12 GMT

I built a datasets to check my code. By accident, I deleted that datasets.

Re: how can I restore the deleted datasets

SASKiwi — Tue, 08 Nov 2016 19:39:32 GMT

Store the SAS datasets you want to keep on disks that are backed up, for example a network server or file share. That way even if you accidentally delete them you can get them restored from backup - it should be standard policy that these are backed up daily.

Re: how can I restore the deleted datasets

Ksharp — Wed, 09 Nov 2016 06:35:59 GMT

No. You can't. Find some Recovery Software in Internet, maybe that could get you the table back.