DATA Step, Macro, Functions and more

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

Reply
New Contributor
Posts: 2

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

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

Super User
Posts: 19,772

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

Posted in reply to priarora91

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?

New Contributor
Posts: 2

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

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.
 
Super User
Posts: 10,020

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

Posted in reply to priarora91

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;
Ask a Question
Discussion stats
  • 3 replies
  • 199 views
  • 0 likes
  • 3 in conversation