Hi, I have multiple XML file, file1.xml, file2.xml, file3.xml. I want to convert each XML file into SAS dataset using macro do loop. I have the following syntax to convert XML file into SAS dataset but I don't know how to use the %do loop to this script. filename File 'C:\Users\Desktop\XML Files\File1.xml';
filename SXLEMAP 'C:\Users\DesktopC:\Users\Desktop\XML Files\File1.map';
libname File xmlv2 xmlmap=SXLEMAP access=READONLY;
/*
* Catalog
*/
proc datasets lib= File; run;
/*
* Contents
*/
proc contents data= File.queryResponse varnum; run;
/*
* Printing
*/
title 'Table queryResponse';
proc print data= File.queryResponse; run;
title;
/*
* Local Extraction
*/
DATA file; SET File.queryResponse; run; Appreciating your help. Thanks!
... View more