04-27-2014 08:40 AM
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?
04-27-2014 11:44 AM
04-27-2014 01:09 PM
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.
04-28-2014 02:51 AM
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.