BookmarkSubscribeRSS Feed
Komninakis
Calcite | Level 5

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

 

6 REPLIES 6
SASKiwi
PROC Star

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
Calcite | Level 5

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
Garnet | Level 18

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
Calcite | Level 5

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
Super User Tom
Super User

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
Calcite | Level 5

Hi Tom.

 

No, I haven't.

 

My question was about the differences in performance between methods.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 959 views
  • 0 likes
  • 4 in conversation