Using XML Mapper and Enterprise Guide to Read Data and Metadata From an XML File

Increasingly, data and metadata are archived together in XML files. This paper works through the process of reading an XML file containing a data table, variable labels, notes about variables, and multiple sets of labels for values - some of which are not associated with any variable. First, the author will use the XML Mapper with the archetypical XML file to create an XMLMAP file. The author will then create an Enterprise Guide project to organize the sequence of operations that follow. The SAS XMLMAP facility of the XML engine uses the XMLMAP file to read the complex, hierarchical, XML file into a set of related tables.