topic Re: SPDE files in SAS Data Management

SPDE files

msd83 — Sun, 27 Apr 2014 12:40:18 GMT

Hi all,

I have some SAS datasets that were created on Windows operation system (Base SAS 9.2). The files have been copied to a Base SAS 9.4 running on a UNIX environment. I am trying to convert these to SPDE data sets using PROC COPY but this does not seem to work. It seems this is becuase the datasets were created in a Windows operating system.

Has anyone got any advice?

Many thanks

Re: SPDE files

Kurt_Bremser — Sun, 27 Apr 2014 15:44:38 GMT

Please provide more information (logs, error messages, examples)

Re: SPDE files

LinusH — Sun, 27 Apr 2014 17:09:39 GMT

It's not clear how you use PROC COPY.

Basically, SPDE tables can never be copied/moved with non SAS tools - search paths etc is included in the metadata portion of the data set. To be able to use PROC COPY in the situation you describe, is to use it on a Remote Libname between the old Windows server and the UNIX server. This could work, but gives awful performance.

If you can use SAS/CONNECT, PROC DOWNLOAD is a far better option.

Otherwise, PROC CPORT/CIMPORT is a method that should be reliable.

Re: SPDE files

Peter_C — Sun, 27 Apr 2014 17:40:16 GMT

Have a look at the dataset option CEDA

(Stands for cross environment data access)

Re: SPDE files

LinusH — Mon, 28 Apr 2014 06:51:09 GMT

Yeah, CEDA could work. But I believe that the tables still needs to be in it's original location, so ability to mount that Windows drive across the network is crucial.

Re: SPDE files

msd83 — Mon, 28 Apr 2014 08:48:55 GMT

I don't have the log information but I will try and provide when I run the PROC copy again.

Re: SPDE files

msd83 — Mon, 28 Apr 2014 08:51:16 GMT

Thanks for the idea, I will explore the CEDA option as well.

Thanks LinusH as well.