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
Please provide more information (logs, error messages, examples)
I don't have the log information but I will try and provide when I run the PROC copy again.
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.
Have a look at the dataset option CEDA
(Stands for cross environment data access)
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.
Thanks for the idea, I will explore the CEDA option as well.
Thanks LinusH as well.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.