SPDE files

[msd83]

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

[Kurt_Bremser]

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

[msd83]

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

[LinusH]

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.

[Peter_C]

Have a look at the dataset option CEDA

(Stands for cross environment data access)

[LinusH]

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.

[msd83]

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

Thanks LinusH as well.