LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 1999, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page