topic Re: xml mapper in SAS Enterprise Guide

xml mapper

Chammag_ — Fri, 27 Sep 2019 11:15:22 GMT

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;

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

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.

Re: xml mapper

ChrisHemedinger — Fri, 27 Sep 2019 11:36:16 GMT

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

Re: xml mapper

Chammag_ — Fri, 27 Sep 2019 11:38:32 GMT

Thank you, will try this

Re: xml mapper

Chammag_ — Fri, 27 Sep 2019 11:43:46 GMT

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

And, O drive is the sas server

Re: xml mapper

elizD — Fri, 27 Sep 2019 11:44:43 GMT

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=p0b4dnu019ycsxn11k3savd51h6k.htm

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;