topic Using MACRO DO LOOP to convert each XML file into dataset in SAS Programming

Using MACRO DO LOOP to convert each XML file into dataset

jei — Fri, 01 Jul 2016 07:30:07 GMT

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!

Re: Using MACRO DO LOOP to convert each XML file into dataset

Kurt_Bremser — Fri, 01 Jul 2016 07:52:34 GMT

%macro do_what_you_want(startnum,endnum);
%do i = &startnum %to &endnum;
filename  file "C:\Users\Desktop\XML Files\File&i..xml";
filename  SXLEMAP "C:\Users\DesktopC:\Users\Desktop\XML Files\File&i..map";
libname  file xmlv2 xmlmap=SXLEMAP access=READONLY;

proc datasets lib=file;
run;

proc contents data=file.queryresponse varnum;
run;

title "Table queryResponse from File File&i..xml";

proc print data=file.queryresponse;
run;

title;

data file&i;
set file.queryresponse;
run;
%end;
%mend;
%do_what_you_want(1,3);

Re: Using MACRO DO LOOP to convert each XML file into dataset

jei — Fri, 01 Jul 2016 08:21:07 GMT

Thanks a lot!