XML Map warning

[Lex_SAS]

I have a simple XML file:

[pre]



Nathaniel Mayer



Noland Strong and the Diablos



Andre Williams



[/pre]

I have created a simple XML map with the SAS XML Mapper 9.2:

[pre]















/singles/single

/singles/single/@id
numeric
integer



/singles/@label
character
string
7



/singles/single/artist
character
string
29



/singles/single/title
character
string
16





[/pre]

This will give a simple table:

[pre]
id label artist title

1 Fortune Nathaniel Mayer Village of Love
2 Fortune Noland Strong and the Diablos Mind over Matter
3 Fortune Andre Williams Jail Beat
[/pre]
It has the following warning message:

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

Why do I get this warning message ??

[Cynthia_sas]

Hi:
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.)

cynthia
[pre]
213 libname for1 xml 'c:\temp\fortune.xml' xmlmap='c:\temp\fortune1.map';
NOTE: Libref FOR1 was successfully assigned as follows:
Engine: XML
Physical Name: c:\temp\fortune.xml
214
215 proc contents data=for1._all_;
216 run;

NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds


217
218 proc print data=for1.singles label;
219 run;

NOTE: There were 3 observations read from the data set FOR1.SINGLES.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds


220
221
222 libname for1 clear;
NOTE: Libref FOR1 has been deassigned.


[/pre]

[Lex_SAS]

Cynthia,

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.

Thanks, Lex

[Cynthia_sas]

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.

cynthia

[Lex_SAS]

Thanks, I might follow-up with Tech Support.