Do you want to read the files into separate SAS data sets or into a single data set since they all have the same structure?
Ok, I was able to code for one XML and get it to read successfully.
What is the next step? I am having a little tough time understanding. Am I just going to run the same code/ change file path 100 times?
Please suggest on how to move forward.
Here is the code I used to read one xml file.
Any suggestions on how to continue adding other XMLs?
A loop?
filename test1 url '.xml file path';
libname test1 XML xml;
proc copy in=test out=work;
run;
proc print;
run
Yes I have all the files.
All the xml files are systematic. The URLs only change slightly based off the issue type.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.