@vanmon1 wrote:
Anyway, yes, I think the solution is to create the structure first with the xlmmapper. Thanks very much for your time and contributions.
Yeah I was trying to reverse engineer your data. If you supplied an XML file, I should be able to use XML mapper to define input as a SAS dataset. But your XML file didn't have a tabular format; each DAILY_GLXXX_RX element was its own table.
Are you sure the XML file you provided is the target format for your final file?
Yes, as I said, I think you should try joining all your datasets until you have the desired flattened format. Then write that out to your XML file.
The forum software can be a bit...ahem...tricky. I can't even attach a SAS EG project!!! In the future, if CSC barfs on your attachment, try a zip file. Ignoring the fact that there are zip file viruses "out there", that format is acceptable to CSC.
I'm going to have to unsubscribe from this one and get back to my real work ;-). Good luck with your project.
Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.
