Date:         Wed, 4 Aug 1999 08:40:21 -0400
Reply-To:     HEATONE <HEATONE@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         HEATONE <HEATONE@WESTAT.COM>
Subject:      Re: Transfering data from HartHanks server on the SUN to Data
Comments: To: Edward C Confer <Edward_C_Confer@FLEET.COM>
Content-Type: text/plain; charset=US-ASCII

 Ed,
   Are all your SAS data sets in a single library, or in only a
few libraries?  Or could they easily be combined into one
library?  If so, and if you have quite a few data sets, it might
be easier to export the entire library (using PROC CPORT), FTP
the single transport file to the other server, and import it
there.  Try something similar to the following on HartHanks.

   LIBNAME library "..." ;
   FILENAME source "..." ;
   FILENAME target FTP "..."
      RECFM= F
      LRECL= 80
      BLOCKSIZE= 8000
      RCMD= "SITE BLOCKSIZE=8000 RECFM=FB LRECL=80"
      HOST= "DataWarehouse"
      USER= "..."
      PROMPT      /* You can hard-code PASS= ... if you wish. */
   ;
   PROC CPORT LIBRARY= library FILE= source ;
   RUN ;
   DATA _NULL_ ;
      INFILE source ;
      FILE target ;
      INPUT ;
      PUT _INFILE_ ;
   RUN ;

Then, on DataWarehouse, you will need to import the library.

   LIBNAME library "..." ;
   FILENAME xptfile "..." ;
   PROC CIMPORT LIBRARY= library INFILE= xptfile ;
   RUN ;

   I have no SAS experience on a SUN, so you will undoubtedly
need to carefully edit the FILENAME TARGET ... statement.  The
key is to make sure the transfer is in binary mode.  When
transporting to an MVS machine from a Windows environment, the
RCMD= statement insures binary transfer; you will need to
research that for your SUN system.

Hope this helps a little,
Ed

Edward Heaton, Sr. Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1550 Research Boulevard, Room 2018, Rockville, MD 20850-3159
voice:  (301) 610-4818                  fax:  (301) 294-3992
mailto:heatone@westat.com              http://www.westat.com


____________________Reply Separator____________________
Subject:    Transfering data from HartHanks server on the SUN to DataWar
Author: Edward C Confer <Edward_C_Confer@FLEET.COM>
Date:       8/3/1999 5:09 PM

     I was hoping for a more effecient method of transfering SAS Data Sets
     from one SUN server to another, ie (from HartHanks to DataWarehouse)
     without having to FTP one file at a time.

     Does anyone have any generic code for this?

     Thanks.

     Ed Confer