topic Re: a SAS loop that imports XML in SAS Programming

a SAS loop that imports XML

KasperMok — Mon, 28 Sep 2015 11:22:24 GMT

I never worked with XML data before, but are trying to make a loop that imports a folder full of XML files into SAS.

I took over the program below, but realises that I get a problem, when I have to import other variables from the file then the two already in use, since some dont have a fixed length.

%macro loop;

%do n=1 %to &no;

data import;

infile "Z:\&&filnavn_&n" LRECL=9999 SCANOVER;
input @'<Review>' +9 medlemnr $9. +20 artikel $10.@@;

run;

proc append base = lookup.review_01 data = import; run;

%end;

%mend loop;

%loop;

Any sugestions?

Re: a SAS loop that imports XML

RW9 — Mon, 28 Sep 2015 13:38:17 GMT

You would be better off looking at the SAS XML Mapper software and the libname xml, rather than trying to write an XML parser yourself:

http://support.sas.com/rnd/base/xmlengine/

Re: a SAS loop that imports XML

KasperMok — Tue, 06 Oct 2015 11:05:24 GMT

Probably, but I dont think I have access to that solution, otherwise I would.

Re: a SAS loop that imports XML

RW9 — Tue, 06 Oct 2015 11:53:13 GMT

Its free, get it here:

http://support.sas.com/downloads/package.htm?pid=713