topic Re: Restore SPDE Data Sets in SAS Data Management

Restore SPDE Data Sets

SvenWagner — Thu, 13 Dec 2018 13:05:28 GMT

Hi,

I stored some data using SPDE in a Windows environment. Unfortunately, a colleague moved and renamed folders. Now, I can see the SPDE files using the Windows Explorer, but SAS does not find them. I already found the following statement in the SPDE Reference:

'CAUTION: Do not rename, copy, or move an SPD Engine data set or its component files using operating system commands.'

Anyway, I ask if there is a possibility to restore my data. In my opinion, it is necessary to update the SPDE metadata, but I don't know how to do so. Any ideas?

Many thanks, Sven

Re: Restore SPDE Data Sets

Ksharp — Thu, 13 Dec 2018 13:21:11 GMT

Can you use LIBNAME to see these tables ?

libname x spde 'd:\your-new-path-name\';

Re: Restore SPDE Data Sets

Kurt_Bremser — Thu, 13 Dec 2018 13:57:29 GMT

You have to recreate the folders EXACTLY as they were (same physical path names), and put all spds buckets into the correct directories.

Recreate the dataset with the code originally used.

You might find the pathnames in the central mdf file with a hex editor.

Strong hint: always have a copy of the data in a straight SAS dataset available and preserve that for long-time storage (backup, archive). .sas7bdat files are uncritical.

Re: Restore SPDE Data Sets

SvenWagner — Mon, 11 Feb 2019 08:08:33 GMT

Obviously, it is possible to spare the path statments for data files, indexes and metadata. If you do so, there is no path entry within the mdf-files and you can move the directory using Windows drag & drop. Certainly not what originally is intended by SPDE, but it works. 🙂