topic Re: Doubt about difference on ftp (via sas code) and export menu option in EG in SAS Enterprise Guide

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

Komninakis — Tue, 22 May 2018 22:33:53 GMT

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

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

SASKiwi — Tue, 22 May 2018 23:37:10 GMT

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?

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

Shmuel — Tue, 22 May 2018 23:37:13 GMT

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.

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

Komninakis — Wed, 23 May 2018 13:27:54 GMT

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.

;>)

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

Tom — Wed, 23 May 2018 13:31:30 GMT

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.

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

Komninakis — Wed, 23 May 2018 13:34:35 GMT

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.

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

Komninakis — Wed, 23 May 2018 13:43:34 GMT

Hi Tom.

No, I haven't.

My question was about the differences in performance between methods.