Copying the data from SAS 9.3 to 9.4

[Mahesh3]

Hi,

Doing the Migration, Can some body please provide the steps to copy the data from SAS9.3 Unix to SAS9.4 Linux

Thanks in advance

[gwootton]

If you're referring to SAS tables (sas7bdat files), are you able to copy them from one server to another using operating system commands?

[Mahesh3]

Thankyou,

If it is just a dataset then i would have simply used the unix commands to copy but i need to copy the related files to  like indexes, catalogues etc to the new server. Need steps to copy the entire data from SAS9.3 to SAS9.4

[gwootton]

I think if they are both SAS 9 you can still just copy them. Here is the relevant documentation:

Compatibility and Migration
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/engsas7bdat/p0xntq65hjj4jkn1nrryzly5fm7u.h...

[MargaretC]

Everything that has been stated works without issues if SAS 9.3 and SAS 9.4 are on the same operating system type (i.e. Windows, Linux or Unix).  

Copying SAS data files (.sas7bdate files) from SAS 9.3 Unix (AIX, Solaris, ....) to SAS 9.4 Linux (RHEL) then operating system commands work, but you will only be able to access the SAS data files in READ mode using the CEDA feature.  And all indexes and catalogs cannot be accessed.  

If you want the catalogs (i.e. user FORMATs) copied and indexes recreated then you need to use the PROC EXPORT/IMPORT or PROC COPY commands.

Let me know if you need more details.

[Mahesh3]

Thank you,

Can you please provide the steps 

[SASKiwi]

I believe you need to look at PROC CPORT and PROC CIMPORT. These provide the most comprehensive functionality.

Also PROC COPY and PROC MIGRATE may be useful.

A simpler approach using PROC UPLOAD is also an option but requires that you have SAS/CONNECT installed and licensed on both SAS installations.