Doubt about difference on ftp (via sas code) and export menu option in EG

[Komninakis]

Hy guys!

What's difference in export a sas data set via ftp in sas code and using export on menu option (file/export).

I'm exporting a dataset between 2 sas servers.

There are performance differences?

/*SAS CODE TO FTP */

%let usuario =user;
%let senha   =pwd;

%macro tranferir(DIROrigem, DIRDestino, Arquivo, user, pass, hostname);

FILENAME getftp FTP "&Arquivo." 
      HOST="&hostname." 
      USER="&user."
      PASS="&pass."
      CD="&DIROrigem." recfm=F ;
FILENAME putftp "&DIRDestino.&Arquivo." recfm=F ;

data _null_;
      INFILE getftp end=eof;
      input;
      FILE putftp;
      put _infile_;
run;

%mend;

Thanks!

Denis Komninakis

[SASKiwi]

One works from your PC - EG menu option -  and the other using code runs from the SAS App server. I suspect the one in code will be faster. Have you tried and what was the result? 

[Komninakis]

Hi SASKiwi.

Thanks for response.

No, I don't tried, becouse table size. It have aproximally 5GB.

I simply used the code.

But, I will try with small table.

;>)

[Shmuel]

You code copies file  "&Arquivo."  from a remote host into your host, bit by bit, as is.

Using IMPORT will transform an external file into a sas dataset in your host.

Using EXPORT will transform a sas dataset from your host into external file.

[Komninakis]

Thanks Shmuel.

I suspect that code run faster than export menu option.

Like SASkiwi said, export run on PC and code run in sas server (better performance).

However, I dont tried. My table is approximatelly 5gb in size.

[Tom]

Do you have SAS/Connect licensed?

If so then just have one SAS session sign onto the other server and remote submit a PROC UPLOAD or PROC DOWNLOAD step.

[Komninakis]

Hi Tom.

No, I haven't.

My question was about the differences in performance between methods.