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?
... View more