BookmarkSubscribeRSS Feed
MariaD
Barite | Level 11

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, 

8 REPLIES 8
SASKiwi
Opal | Level 21

@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
Barite | Level 11

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

 

Regards, 

SASKiwi
Opal | Level 21

@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
SAS Employee
This is correct. You need to use a migration tool to be able access SPDS tables created on UNIX SAS with Linux SAS.

MariaD
Barite | Level 11

Thanks @MargaretC . What migration tool do you recommend?

SASKiwi
Opal | Level 21

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

MargaretC
SAS Employee

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.

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 8 replies
  • 796 views
  • 1 like
  • 4 in conversation