- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.