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.
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.
cynthia
That was IT's suggested approach...use EZTrieve to create a snap text extract and download it....sorta old school, isn't it.
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)
cynthia
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.