Date: Thu, 22 Jul 2004 12:13:07 -0700
Reply-To: "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject: Re: Integration-Communicating with PC SAS and Mainframe
To my knowledge the biggest hurdle is to allocate the GDS on MVS from the
I'd suggest maybe something like this: have your PC job extract the data,
have PC SAS FTP a job directly into the job entry system (JES) to allocate
the GDS, and then FTP the data from PC SAS to the GDS.
Something like this can upload the JCL directly to JES to allocate the GDS:
<untested and plagiarized from various SAS-L posts>
put 'open <ftp-server>'
/ 'quote site filetype=jes'
/ 'put GDS_JCL.txt'
x ftp -s <FtpScript>;
</ untested and plagiarized from various SAS-L posts>
Now your GDS is ready and you can use SAS PC FTP to upload to it.
DDS Data Extraction
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jeomoan
Sent: Thursday, July 22, 2004 11:09 AM
Subject: Integration-Communicating with PC SAS and Mainframe
I am to automate an FTP process between Windows and Mainframe(MVS, I
use ISPF) . This also involves creation of a dataset in Mainframe.
Outcome of my PC Based data extraction and cleaning is a text file
that i will have to export into a mainframe datafile for further
processing. The present process, i generate the text file in PC SAS,
Create a new dataset(generation dataset) in Mainframe and using the
Mainfram interface utility i FTP the text file to maniframe file. I
read about SAS capabilities to automate such processes but did not get
any help specific to this. I have done ftp but stuck at Allocating a
Please let me know your thoughts