Date:         Fri, 30 Dec 2005 13:41:01 -0500
Reply-To:     "Droogendyk, Harry" <harry.droogendyk@RBC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Droogendyk, Harry" <harry.droogendyk@RBC.COM>
Subject:      Re: Proc Download compared to Data Step Set Statement advice
Content-Type: text/plain; charset="iso8859-1"

Paul:

I'm not sure if RLS ( remote library services ) provide time savings in
terms of data transfer, but using RLS you can certainly remove the
explicit download step, whether that be via DOWNLOAD or SET.

eg.  on PC

%let mvs_IP = mainframe.ip.address;
libname mvs slibref=mvslibnm server=mvs_IP;

proc print data=mvs.mainframe_data ( keep = id fld1 fld2 );
run;

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Choate, Paul@DDS
Sent: 2005, December, 30 1:26 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Download compared to Data Step Set Statement advice

I'm running a SAS9 TCP remote connect from my PC to MVS over a Novell
network and a t3 line.  I move data from MVS to my PC regularly; usually
I've reduced it sufficiently on MVS that download performance isn't an
issue.  Occasionally I have to draw larger data across the connection.

My experience is that proc download run from the MVS side transfers the
data somewhat faster than data step set statement in my local session
from the remote file to a local file.  Both CPU and wall clock time are
reduced.

With data set options such as "keep" and the where clause I can usually
subset the data I need, and so using the download procedure saves me
substantial time.  I generally use character compression and drop
unnecessary fields before the transfer.

I occasionally do things like make a cport file and then filename ftp
it, perhaps zipping the file first, but only if the file is extremely
large.  Usually though, the large files are around 0.5-1.0 gb and my
quickest route is to not preprocess it at all.

My question is why is Download faster than a set statement?  And does
anyone have other time saving recommendations for adhoc file transfer
like this?

TIA & Best Wishes for a Happy 2006 to all -

Paul Choate
DDS Data Extraction
(916) 654-2160
_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.