so i am working with xml for the first time. it basically categorizes a bunch of variables into different types with different attributes. the numer of variables and name of variables are dynamic and will be different each time.
what i need to do is search through the xml statement and break it down into smaller pieces for further processing (of course, if there is an easier way, let me know) ![]()
for example,
<A>.............................<END><B>.......<END><C>........................................................................<END>
it's easy to find the starting position of A, B, or C, but haven't had any luck getting the "end" position. i used find, findw, index, indexw, and all, nothing seems to work for me.
i just want it to break into <A>...........................<END> into 1 variable, so on for B and C into their own variables as well.
then after that, i will use variables within each segment to further process the dataset.
thank you.
Did you check xml engine of libname?
libname x xml 'c:\x.xml' ;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.