xml mapper

[Chammag_]

Hi is the sas xml mapper  XMLv2 compatable with EG 7 version ,we are trying to import an xml document and its not reading the xmle map file created  by the mapper 

libname NHL   '\\jdgsasappsvr\CVM\BI and BA Reporting\RTDM Testing\Map test';

filename MAP 'O:\CVM\BI and BA Reporting\RTDM Testing\Map test\map.map';

libname NHL xml xmlmap=MAP;

libname NHL xml  xmlmap=MAP;

proc print data=NHL.Request_map;

run;

23         GOPTIONS ACCESSIBLE;

24         libname NHL xml  xmlmap=MAP;

NOTE: Libref NHL was successfully assigned as follows:

      Engine:        XML

      Physical Name: NHL

25        

26         proc print data=NHL.Request_map;

ERROR: Physical file does not exist, O:\CVM\BI and BA Reporting\RTDM Testing\Map test\map.map.

ERROR: Encountered during XMLMap parsing at or near line 1, column 1.

ERROR: XML describe error: Internal processing error.

[ChrisHemedinger]

XML Mapper (and XML engine) works fine in EG.  I think the issue might be that the O: drive isn't visible to your SAS server.  If that's a drive you have mapped on your PC, you might need to express the file path as a UNC path (as you did with the XML data source) or copy the XML map file to a location on your server.  (You can manage that with the Copy Files task in EG.)

[Chammag_]

Thank you, will try this 

[Chammag_]

is it compatible with SAS EG 7.1, this is the version we are using.

And, O drive is the sas server

[elizD]

Hey, I'm not by any means an expert on reading XML, but I did look at the doc:

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=engxml&docsetTarget=p0...

The example has two filename statements, one to the xml file and one to the map. Looks like your first libname statement needs to be replaced with a  filename statement that identifies the xml file.  Also, try the xmlv2 engine in the libname statement.

I ran this example from the doc successfully using EG 7.13. Hope this helps.

filename nhl 'C:\Example\Nhl.xml'; /*1*/
filename map 'C:\Example\Nhl.map'; /*2*/

libname nhl xmlv2 xmlmap=map; /*3*/

proc print data=nhl.teams; /*4*/
run;