Optimise a simple SAS code

[Patrick]

Hi Chris

Point taken.

I'm not 100% convinced that you're right with everything (especially point 2) but I definitely need to do some more reading & testing first before continuing this discussion.

Thanks

Patrick

[Haikuo]

Hi Chris,

We are doing many data transferring in between different hosts and platforms, mainframe to Windows servers, Unix server to Windows server and back and forth. What we have found that FTP (or sFTP) binary is the fastest among many solutions including proc download. Another team claimed that using Axway to do the transferring is in par of FTP, but I haven't got a chance to test it out myself.

And of course, it is certainly an appropriate topic for SAS tech support to investigate on.

Haikuo

[ChrisNZ]

Hi Haikuo.

FTP's purpose is indeed to transfer files, and it is fast.

If it is available to the user, it is certainly a viable option, but you have to transfer to the FTP server first, and the whole process is not synchronous and not as simple.

If FTP is not available to the user or if the user wants a quick and easy way for one-off transfer, proc download remains in the sas world and is the way to go.

Both options work and choice is good.

Chris