The SAS Output Delivery System and reporting techniques

XML Map warning

Reply
SAS Employee
Posts: 47

XML Map warning

I have a simple XML file:

[pre]



Nathaniel Mayer
Village of Love


Noland Strong and the Diablos
Mind over Matter


Andre Williams
Jail Beat


[/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 ??
SAS Super FREQ
Posts: 8,744

Re: XML Map warning

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]
SAS Employee
Posts: 47

Re: XML Map warning

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
SAS Super FREQ
Posts: 8,744

Re: XML Map warning

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
SAS Employee
Posts: 47

Re: XML Map warning

Thanks, I might follow-up with Tech Support.
Ask a Question
Discussion stats
  • 4 replies
  • 415 views
  • 0 likes
  • 2 in conversation