DATA Step, Macro, Functions and more

VSAM

Reply
Super Contributor
Posts: 578

VSAM

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.

SAS Super FREQ
Posts: 8,868

Re: VSAM

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

Super Contributor
Posts: 578

Re: VSAM

Posted in reply to Cynthia_sas

That was IT's suggested approach...use EZTrieve to create a snap text extract and download it....sorta old school, isn't it.

SAS Super FREQ
Posts: 8,868

Re: VSAM

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

Ask a Question
Discussion stats
  • 3 replies
  • 203 views
  • 0 likes
  • 2 in conversation