Importing XML Documents Using an XMLMap |
The XML engine imports only XML documents that conform to the markup types supported in the XMLTYPE= option. Attempting to import free-form XML documents that do not conform to the specifications required by the supported markup types will generate errors. To successfully import files that do not conform to the XMLTYPE= markup types, you can create a separate XML document, called an XMLMap.
If your XML document does not import successfully, rather than transform the document, you can tell the XML engine how to interpret the XML markup in order to successfully import the XML document. You create an XMLMap that contains specific XMLMap syntax, which is XML markup. The XMLMap syntax tells the XML engine how to interpret the XML markup into a SAS data set or data sets, variables (columns), and observations (rows). See XMLMap Files for the XML Engine.
After you have created the XMLMap, use the XMLMAP= option in the LIBNAME statement to specify the file.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.