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
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.