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 (October 1997, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 22 Oct 1997 12:56:00 -0400
Reply-To:     "Alderton, David" <dla5@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Alderton, David" <dla5@CDC.GOV>
Subject:      Re: transporting data: MVS/TSO -> PC
Content-Type: text/plain

SAS-L, I want to thank everyone one who responded to my earlier request on transporting data from a mainframe (TSO) to my PC (NT). Most people suggested that I use CPORT on the mainframe side, download the file, then use CIMPORT on the PC side to turn the file back into a SAS dataset. Several other people suggested I look into SAS/Connect to directly download the file. Since the difficult part of SAS/Connect is writing the script file to handle the handshaking between PC SAS and the mainframe and this had already been done by a coworker, I opted for the SAS/Connect solution. It took a bit to get the script working on the PC end and a couple of phone calls to have my mainframe account TCP enabled. However, it was not that much work and probably less work than for me to learn how to run SAS on the mainframe, get sufficient space to save the transport file, etc. The real benefits from going with SAS/Connect was: (a) I can easily use this again in the future and (b) the data transfer from the mainframe to the PC was amazingly fast. The PC SAS file is 155.6 meg in size, 122459 observations and 268 variables. It only took 17 minutes and 10 seconds to download! Using my normal transfer utility, it would have taken close to 90 minutes to transfer.

Again, thanks to all. David. David L. Alderton, Ph.D. Centers for Disease Control and Prevention HIV/AIDS Surveillance Branch Atlanta, GA -- DLA5@CDC.gov

---------- > From: Alderton, David > To: SAS List > Subject: transporting data: MVS/TSO -> PC > Date: Monday, October 20, 1997 8:55AM > > Can someone give me the gist of transporting SAS datasets from > a MVS/TSO environment to a PC (NT)? I've never done this > before and I feel like I'm chasing my tail with the > documentation. Moreover, everything seems to lead to P-195 > which I do not have. Here are a few parameters... > > The SAS file I want is under MVS/TSO and was created with > version 6. It is an uncomplicated data set; it does not have > a lot of supporting formats, etc. However, it is big (in PC > terms it will be about 150 meg). > > I want to get it off the mainframe and put it on my PC, > running SAS v. 6.12 under NT, and then convert it back to a > SAS dataset. > > I had planned on using the same connect utility to move it > that I normally use for moving flat files from the mainframe > to my PC (its called DynaComm v. 3.6). However, I do have > SAS Connect but again, I don't have a clue how to use it.


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