topic Re: XML Map warning in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44833#M5932 Honestly, I don't usually worry about those warnings unless the MAP doesn't work to read the data at all. For issues with XML Mapper, you might want to work with Tech Support.<BR /> <BR /> cynthia Fri, 22 Jan 2010 02:26:17 GMT Cynthia_sas 2010-01-22T02:26:17Z XML Map warning https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44830#M5929 I have a simple XML file:<BR /> <BR /> [pre]<BR /> <BR /> <SINGLES label="Fortune"><BR /> <SINGLE id="01"><BR /> <ARTIST>Nathaniel Mayer</ARTIST><BR /> <TITLE>Village of Love</TITLE><BR /> </SINGLE><BR /> <SINGLE id="02"><BR /> <ARTIST>Noland Strong and the Diablos</ARTIST><BR /> <TITLE>Mind over Matter</TITLE><BR /> </SINGLE><BR /> <SINGLE id="03"><BR /> <ARTIST>Andre Williams</ARTIST><BR /> <TITLE>Jail Beat</TITLE><BR /> </SINGLE><BR /> </SINGLES><BR /> [/pre]<BR /> <BR /> I have created a simple XML map with the SAS XML Mapper 9.2:<BR /> <BR /> [pre]<BR /> <BR /> <!-- ############################################################ --><BR /> <!-- 2010-01-21T17:10:00 --><BR /> <!-- SAS XML Libname Engine Map --><BR /> <!-- Generated by XML Mapper, 902000.3.6.20090116170000_v920 --><BR /> <!-- ############################################################ --><BR /> <!-- ### Validation report ### --><BR /> <!-- ############################################################ --><BR /> <!-- Column (label) in table (singles) has an XPath outside the scope of the table path. The contents of this column may not correspond to other row values and/or may be missing entirely. --><BR /> <!-- XMLMap validation completed successfully. --><BR /> <!-- ############################################################ --><BR /> <SXLEMAP name="singles" version="1.2"><BR /> <!-- ############################################################ --><BR /> <BR /> <TABLE name="singles"><BR /> <TABLE-PATH syntax="XPath">/singles/single</TABLE-PATH><BR /> <COLUMN name="id"><BR /> <PATH syntax="XPath">/singles/single/@id</PATH><BR /> <TYPE>numeric</TYPE><BR /> <DATATYPE>integer</DATATYPE><BR /> </COLUMN><BR /> <BR /> <COLUMN name="label" retain="YES"><BR /> <PATH syntax="XPath">/singles/@label</PATH><BR /> <TYPE>character</TYPE><BR /> <DATATYPE>string</DATATYPE><BR /> <LENGTH>7</LENGTH><BR /> </COLUMN><BR /> <BR /> <COLUMN name="artist"><BR /> <PATH syntax="XPath">/singles/single/artist</PATH><BR /> <TYPE>character</TYPE><BR /> <DATATYPE>string</DATATYPE><BR /> <LENGTH>29</LENGTH><BR /> </COLUMN><BR /> <BR /> <COLUMN name="title"><BR /> <PATH syntax="XPath">/singles/single/title</PATH><BR /> <TYPE>character</TYPE><BR /> <DATATYPE>string</DATATYPE><BR /> <LENGTH>16</LENGTH><BR /> </COLUMN><BR /> <BR /> </TABLE><BR /> <BR /> </SXLEMAP><BR /> [/pre]<BR /> <BR /> This will give a simple table:<BR /> <BR /> [pre]<BR /> id label artist title<BR /> <BR /> 1 Fortune Nathaniel Mayer Village of Love <BR /> 2 Fortune Noland Strong and the Diablos Mind over Matter<BR /> 3 Fortune Andre Williams Jail Beat <BR /> [/pre]<BR /> It has the following warning message:<BR /> <BR /> <B>Column (label) in table (singles) has an XPath outside the scope of the table path. The contents of this column may not correspond to other row values and/or may be missing entirely</B><BR /> <BR /> Why do I get this warning message ?? Thu, 21 Jan 2010 22:25:24 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44830#M5929 Lex_SAS 2010-01-21T22:25:24Z Re: XML Map warning https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44831#M5930 Hi:<BR /> I saved your files as fortune.xml and fortune1.map and when I ran the code below, I did not get the same message. You might want to open a track with Tech Support on this. (Code in log below. My output was the same as yours.)<BR /> <BR /> cynthia<BR /> [pre]<BR /> 213 libname for1 xml 'c:\temp\fortune.xml' xmlmap='c:\temp\fortune1.map';<BR /> NOTE: Libref FOR1 was successfully assigned as follows:<BR /> Engine: XML<BR /> Physical Name: c:\temp\fortune.xml<BR /> 214<BR /> 215 proc contents data=for1._all_;<BR /> 216 run;<BR /> <BR /> NOTE: PROCEDURE CONTENTS used (Total process time):<BR /> real time 0.06 seconds<BR /> cpu time 0.00 seconds<BR /> <BR /> <BR /> 217<BR /> 218 proc print data=for1.singles label;<BR /> 219 run;<BR /> <BR /> NOTE: There were 3 observations read from the data set FOR1.SINGLES.<BR /> NOTE: PROCEDURE PRINT used (Total process time):<BR /> real time 0.06 seconds<BR /> cpu time 0.00 seconds<BR /> <BR /> <BR /> 220<BR /> 221<BR /> 222 libname for1 clear;<BR /> NOTE: Libref FOR1 has been deassigned.<BR /> <BR /> <BR /> [/pre] Thu, 21 Jan 2010 23:54:57 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44831#M5930 Cynthia_sas 2010-01-21T23:54:57Z Re: XML Map warning https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44832#M5931 Cynthia,<BR /> <BR /> Sorry for the confusion, but the warning is in the XML Map, not when using the Map in SAS. It is the XML Mapper application that shows the error.<BR /> <BR /> Thanks, Lex Fri, 22 Jan 2010 01:06:55 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44832#M5931 Lex_SAS 2010-01-22T01:06:55Z Re: XML Map warning https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44833#M5932 Honestly, I don't usually worry about those warnings unless the MAP doesn't work to read the data at all. For issues with XML Mapper, you might want to work with Tech Support.<BR /> <BR /> cynthia Fri, 22 Jan 2010 02:26:17 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44833#M5932 Cynthia_sas 2010-01-22T02:26:17Z Re: XML Map warning https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44834#M5933 Thanks, I might follow-up with Tech Support. Fri, 22 Jan 2010 04:12:58 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/XML-Map-warning/m-p/44834#M5933 Lex_SAS 2010-01-22T04:12:58Z