03-19-2013 01:13 PM
I use SAS on UNIX. I have a need to read a VSAM file from an IBM Mainframe. Any suggestions on where to start? The VSAM infile options seem to be written in the case when the vsam file is on the same server.
03-19-2013 02:32 PM
Wow, that is a blast from the past. I'd recommend working with Tech Support on this: SAS(R) 9.3 VSAM Processing for z/OS I do know that it is possible to read VSAM datasets using SAS. The mechanism that you use might be different depending on whether you have SAS on the mainframe or not or how you get to the mainframe to point to the file.
As I remember my VSAM days, sometimes mainframe shops make "sequential" versions of VSAM datasets for reporting purposes with other languages -- at least they did on my old system when we used EZTREVE and SAS for adhoc reporting.
But, ultimately, I'd recommend working with Tech Support on this.
03-19-2013 11:08 PM
Well, VSAM is sort of old school. Not as old as ISAM and you can read VSAM with SAS, but apparently your mainframe folks never had the need to create a sequential version of the file. Oh, ick, I wouldn't use EZTREVE (or EXTrieve) to make the extract. I think there are actually IBM utilities that will make the extract file for you. Or I wrote a COBOL program once to do it. (Not fun)