SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

data import

Reply
Contributor fre
Contributor
Posts: 35

data import

[ Edited ]

* deleted, not a good question *

Super User
Super User
Posts: 7,079

Re: data import & XML

SAS has tools for parsing XML, but it assumes the XML is in a file and not in a variable.

I would import the first spreadsheet and write the XML into a file and try importing that.

 

PS. Your XLSX files are hard to view on the SAS website. The first one doesn't show the full XML in the column you mentioned and the second one doesn't render at all. You should just paste an example of the XML as text into your question (use the {i} icon to paste into a code box to preserve formatting) if you want help with how to parse it.

Contributor fre
Contributor
Posts: 35

Re: data import & XML

Thank you Tom for your suggestion.

I've integrated the XML code in the original question.

Hope this is more clear now.

Ask a Question
Discussion stats
  • 2 replies
  • 166 views
  • 0 likes
  • 2 in conversation