topic Import XML file in SAS Programming

Import XML file

MariaD — Fri, 16 Dec 2022 15:57:43 GMT

Hi folks,

I'm trying to import an XML file. My first attempt was using xmlv2 engine but the following error appear:

XML data is not in a format supported natively by the XML libname engines.

After that, I tried to import it using xml engine. In this case, the libname is created and I can see the tables inside but all data appear as null/missing. I don't have xmlmap, I only have a xsd file. Any idea?

Regards.

Re: Import XML file

ballardw — Fri, 16 Dec 2022 17:29:12 GMT

Pretty much any time you get an error or unexpected results you should copy the entire log steps related to the question, such as filename, libname, data step and or Proc statements. Copy the text from the LOG and then on the forum open a text box using the </> icon and paste the copied text. The text box preserves formatting of any information SAS provides. The main message windows will reformat text and may move or make parts of the messages less informative.

Re: Import XML file

MariaD — Fri, 16 Dec 2022 18:10:23 GMT

Thanks, finally I resolved using the option automap=replace with xmlv2 engine.

Regards,