09-25-2014 03:50 PM
When I try to use the XML mapper, create a map file and try to import the XML file into SAS, it isn't importing any observations. In addition, when I try to open the table, SAS says "object reference not set to an instance of an object." Then when I click the table again, it opens up with no observations. Does anyone have an idea of what is going on?
09-25-2014 04:06 PM
I've never had luck with the XML Mapper...
The auto map has worked for me though, the first argument is a path to your XML file, the second filename statement will be created by default.
Then check the contents using proc contents, as you may have to merge tables.
If this doesn't work you may want to work with tech support or at least post an example of your XML file and/or code that isn't working.
filename myxml "Path to XML.xml";
filename mymap "Path to create map file.map";
libname myxml xmlv2 automap=replace xmlmap=mymap;
proc contents data=myxml._all_;
filename myxml clear;
filename mymap clear;