Desktop productivity for business analysts and programmers

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

Reply
New Contributor
Posts: 4

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

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

 

Super User
Posts: 3,857

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

Posted in reply to Komninakis

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? 

New Contributor
Posts: 4

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

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.

 

;>)

Trusted Advisor
Posts: 1,831

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

Posted in reply to Komninakis

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.

New Contributor
Posts: 4

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

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.

 

 

Super User
Super User
Posts: 7,932

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

Posted in reply to Komninakis

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.

New Contributor
Posts: 4

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

[ Edited ]

Hi Tom.

 

No, I haven't.

 

My question was about the differences in performance between methods.

Ask a Question
Discussion stats
  • 6 replies
  • 148 views
  • 0 likes
  • 4 in conversation