topic Re: Parsing XML Files in Z/OS in SAS Programming

Parsing XML Files in Z/OS

ismahero2 — Wed, 19 May 2021 21:44:04 GMT

Hi,

I have used the xmlv2 engine in SAS to parse some XML files. However, now I am receiving more and bigger files and I want to parse them on the IBM Z/OS mainframe to take advantage of the processing power. However, I haven't found any documentation on how to parse XML files using the xmlv2 engine in the Z/OS environment. Normally I would create a map of the XML file and then use that map along with the xmlv2 engine to generate a SAS dataset from the XML file.

My code in SAS Studio or EG would look like this:
filename XMLFILES (

"file1"

"file2"

);

filename XMLMAP 'address/nameofmap.map';

libname XMLFILES xmlv2 xmlmap=XMLMAP;

libname PERMOUT 'address/permanent';

Proc Datasets LIB=XMLFILES;

COPY OUTLIB=PERMOUT;

RUN; QUIT;

I will like to do something similar, if possible, but in the Z\OS environment. Have anyone done this? Any documentation or examples on how to do this on the IBM Mainframe?

Re: Parsing XML Files in Z/OS

SASKiwi — Wed, 19 May 2021 22:21:01 GMT

According to this doc the XMLV2 engine is Production on z/OS in SAS 9.4. What is your mainframe SAS version? As long as it is at least 9.4 the engine should work the same as on other operating systems.

Re: Parsing XML Files in Z/OS

ismahero2 — Wed, 19 May 2021 22:39:06 GMT

Hi,

I just checked and we have SAS 9.3. Will this be a dealbreaker when it comes to use SAS to parse the XML files?

Re: Parsing XML Files in Z/OS

SASKiwi — Wed, 19 May 2021 23:03:30 GMT

Apparently it is pre-production in SAS 9.3, so you could try it at your own risk. It is unlikely to work as reliably in 9.3. I personally wouldn't use it for any business-critical processes.