topic Reading Multiple XML files from a folder into one SAS data set in SAS Programming

Reading Multiple XML files from a folder into one SAS data set

priarora91 — Thu, 23 Mar 2017 11:06:13 GMT

Please provide way to read multiple xml files(more than 1000) from a folder into one sas data set.

Re: Reading Multiple XML files from a folder into one SAS data set

Reeza — Thu, 23 Mar 2017 13:33:33 GMT

Are they all the same structure?

Do you have code to read data from one file? Are all files in same directory or different directories?

Re: Reading Multiple XML files from a folder into one SAS data set

priarora91 — Thu, 23 Mar 2017 14:20:11 GMT

Yes, I have code to read xml file.

This is the code.

filename datafile '\\10.181.253.36\iqc_active\SAS\SOA-MFE-0000000082308698-2016-11-17-120102170.xml';

filename mapfile '\\10.181.253.36\iqc_active\SAS\stu.map';

libname datafile xmlv2 xmlmap=mapfile automap=replace;

All the XML files are of same format and are placed in single directory.

Re: Reading Multiple XML files from a folder into one SAS data set

Ksharp — Fri, 24 Mar 2017 02:53:59 GMT

Your code should be like.

If you have real xml map, that is another story .


filename mapfile temp;
libname xx   xmlv2   
 '\\10.181.253.36\iqc_active\SAS\SOA-MFE-0000000082308698-2016-11-17-120102170.xml'
       xmlmap=mapfile automap=replace;

proc copy in=xx out=work;
run;