IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Moving a Multitude of SAS data sets from mainframe to PC


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Fri Aug 23, 2013 1:08 am
Reply with quote

I have a large number of SAS data sets that needed to be transferred to a PC from the mainframe. We usually use PROC CPORT or the XPORT engine to accomplish this task. In doing some reading, I came across the acronym CEDA (Cross Environment Data Access). If your mainframe system has UNIX System Services then your system has HFS (hierarchical file structure). Supposedly one should be able to put one's SAS data sets into a HFS directory and then FTP the data sets to the PC without constructing SAS transportable files.

First - Is anyone used this method and if so, could they point me to some literature providing some detail on the process?

Second - If no one has used this method could anyone point me to some literature telling me how to create a directory in HFS using a batch setup with JCL?

Charles Wolters
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Aug 23, 2013 11:41 am
Reply with quote

You could always try to see if you have SAS/Connect installed.

That way you can copy directly from the z/OS mainframe to the PC
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Tue Aug 27, 2013 7:37 pm
Reply with quote

Hello,
Quote:
could anyone point me to some literature telling me how to create a directory in HFS using a batch setup with JCL?


You could create USS directory from SAS piping and submit the SAS in batch.

Code:
filename oecmd pipe ('mkdir /unix/directory/being/created/'); 
data _null_;                                     
infile oecmd;                                   
run;       

or
Code:
libname xx '/unix/directory/being/created/';   
data xx._null_;                 
run;           

I have not tried out CEDA completely,since I don't have easy access to PC SAS, but the methodology can be tested, what happened when you tried?

1. create a USS directory which will hold the SAS datasets. let it be "/unix/directory/being/created"
2. assign the USS directory in libname statement with OUTREP=WINDOWS_32

3. write a test dataset into the USS directory.
Code:
libname OUTLIB '/unix/directory/being/created' outrep=WINDOWS_32;
data OUTLIB.class;                                           
set sashelp.class;                                         
run;       

4. FTP the file from USS to PC in BINARY mode and try to view the dataset in PC SAS.
5. I envy you for having PC SAS :-)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Store the data for fixed length COBOL Programming 1
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
Search our Forums:

Back to Top