topic Re: Copying the data from SAS 9.3 to 9.4 in Administration and Deployment

Copying the data from SAS 9.3 to 9.4

Mahesh3 — Fri, 10 Dec 2021 13:47:13 GMT

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

Re: Copying the data from SAS 9.3 to 9.4

gwootton — Fri, 10 Dec 2021 13:54:21 GMT

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

Re: Copying the data from SAS 9.3 to 9.4

Mahesh3 — Fri, 10 Dec 2021 14:30:37 GMT

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

Re: Copying the data from SAS 9.3 to 9.4

gwootton — Fri, 10 Dec 2021 16:27:18 GMT

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.htm

Re: Copying the data from SAS 9.3 to 9.4

MargaretC — Fri, 10 Dec 2021 16:35:16 GMT

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.

Re: Copying the data from SAS 9.3 to 9.4

Mahesh3 — Fri, 10 Dec 2021 16:49:45 GMT

Thank you,

Can you please provide the steps

Re: Copying the data from SAS 9.3 to 9.4

SASKiwi — Fri, 10 Dec 2021 21:02:21 GMT

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.