topic SAS Data-set Migration from Unix To Window in SAS Programming

SAS Data-set Migration from Unix To Window

japsas100 — Fri, 20 Mar 2020 15:18:21 GMT

Dear All,

I would like to migrate a large number of sas files from UNIX to the window environment including sas format & index.

Is there any best way to migrate a large number of files?

Regards

Japs

Re: SAS Data-set Migration from Unix To Window

s_lassen — Fri, 20 Mar 2020 15:48:00 GMT

I think it may be worth taking a look at PROC CPORT, which writes SAS files to a portable transport format.

On the Unix platform use e.g.

filename out "<unit path for transport file>";
proc cport library=<sas library> file=out datecopy;
run;

If you are going to FTP the file from Unix to Windows, I think you can even get away with using an FTP filename for the output.

I used the DATECOPY option, which will keep the original creation and modification dates of the tables and catalogs, which I think is very nifty.

On the Windows platform, you then use PROC CIMPORT to import the file:

filename cport "Windows file path";
proc cimport library=<Windows library> infile=cport;
run;

Again, if you were planning on using FTP on Windows to get the file from Unix, you can use an FTP filename to read the file from the Unix server.

Take a look at the documentation for the procedures, there are many other options available (what to port, how to compress the output files, etc.).

Re: SAS Data-set Migration from Unix To Window

SASKiwi — Sat, 21 Mar 2020 02:25:11 GMT

As well as @s_lassen 's suggestions, another particularly simple way if you have SAS/CONNECT on both source and target servers is to use PROC UPLOAD. For example you can migrate an entire SAS library by doing this:

proc upload inlib=MySource outlib=MyTarget;
run;

More details here: https://documentation.sas.com/?docsetId=connref&docsetTarget=n1vaverm2ole11n1j6q0qg3qtz5g.htm&docsetVersion=9.4&locale=en

I recommend you check out the Migration Focus Area for a lot of useful knowledge on this topic: https://support.sas.com/rnd/migration/

Re: SAS Data-set Migration from Unix To Window

japsas100 — Tue, 24 Mar 2020 21:16:48 GMT

@SASKiwi

Thanks for the suggestion.

Could you please suggest how we can setup sas connect between the sas window and UNIX server?

Re: SAS Data-set Migration from Unix To Window

SASKiwi — Wed, 25 Mar 2020 19:16:04 GMT

@japsas100 - It is a separate SAS product. Do you have it installed and licensed?

Re: SAS Data-set Migration from Unix To Window

japsas100 — Wed, 25 Mar 2020 19:17:43 GMT

@SASKiwi

Yes, we do have sas connect on the window and Unix environment.

Re: SAS Data-set Migration from Unix To Window

SASKiwi — Wed, 25 Mar 2020 20:32:26 GMT

Is SAS/CONNECT working? Is anyone using it? Or does it need to be configured to get it working?

Re: SAS Data-set Migration from Unix To Window

japsas100 — Wed, 25 Mar 2020 20:34:24 GMT

@SASKiwi

We never used the sas connect. We need to configure it first.

Re: SAS Data-set Migration from Unix To Window

SASKiwi — Wed, 25 Mar 2020 22:24:55 GMT

Please refer to the documentation for this:

https://documentation.sas.com/?docsetId=biasag&docsetTarget=n04012intelplatform00srvradm.htm&docsetVersion=9.4&locale=en

I would strongly advise opening a Tech Support track on this as they are in a much better position to guide you through the required steps. You need to run the SAS Deployment Wizard to create the required SAS/CONNECT servers. This needs to be done on both of your servers. There are also decisions to make on the type of authentication to use and any encryption required.

Re: SAS Data-set Migration from Unix To Window

japsas100 — Thu, 26 Mar 2020 17:44:03 GMT

@SASKiwi Thanks

One of our servers we don't have sas/connect so we cant transfer files via sas/connect

Is there any other way to transfer files from unix to window?

Re: SAS Data-set Migration from Unix To Window

SASKiwi — Thu, 26 Mar 2020 22:15:55 GMT

@japsas100 - Refer to @s_lassen 's response.