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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.