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
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?
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.
;>)
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.
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.
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.
Hi Tom.
No, I haven't.
My question was about the differences in performance between methods.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.