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

[priarora91]

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

[Reeza]

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?

[priarora91]

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.

[Ksharp]

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;