Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

[MariaD]

Hi folks, 

We're changing our SAS Server from Unix (9.4 M5, SPDS 5.3) to Linux (9.4 M6, SPDS 5.4). We copied a SPDS table from our Unix Server to our Linux Server and when we tried to open it the following error appears:

ERROR: Unable to open due to incompatible data file version number

Any ideia why? Is there any compatibility issue between Unix and Linux server?

Regards, 

[SASKiwi]

@MariaD - I suggest you try the Migration Compatibility Calculator to identify what types of SAS files need converting: https://support.sas.com/rnd/migration/planning/files/calculator/

I suspect you need to convert SPDS tables when changing operating systems.

[MariaD]

@SASKiwi , I believe you are right. May I use a PROC COPY to do it?

Regards, 

[SASKiwi]

@MariaD - I'm not familiar with SPDS tables, but you could always copy these to Base SAS tables first, migrate those, then write them back to the destination SPDS library on your new server.

[MargaretC]

This is correct. You need to use a migration tool to be able access SPDS tables created on UNIX SAS with Linux SAS.

[MariaD]

Thanks @MargaretC . What migration tool do you recommend?

[Ksharp]

proc cport + proc cimport

[SASKiwi]

@MariaD  - See the PROC MIGRATE example in your other migration-related post.

[MargaretC]

I have a note that PROC MIGRATE does not work with SPDS.  Your best bet is to use PROC CPORT and PROC CIMPORT like others have said.