SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SPDE files

Reply
Contributor
Posts: 23

SPDE files

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

Super User
Posts: 6,972

Re: SPDE files

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 23

Re: SPDE files

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

Super User
Posts: 5,260

Re: SPDE files

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.

Data never sleeps
Valued Guide
Posts: 2,175

Re: SPDE files

Have a look at the dataset option CEDA

(Stands for cross environment data access)

Super User
Posts: 5,260

Re: SPDE files

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.

Data never sleeps
Contributor
Posts: 23

Re: SPDE files

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

Thanks LinusH as well.

Ask a Question
Discussion stats
  • 6 replies
  • 513 views
  • 0 likes
  • 4 in conversation