Hi: You might want to ask Tech Support. I thought that the XML Mapper looked for a valid XML Processing instruction at the top of the XML file that you were feeding into the mapper. If I go out to JSON.ORG, they are touting JSON as an "alternative" to XML -- http://www.json.org/xml.html So my guess is that a JSON file won't work with the XML Mapper. The other issue that you might want to check with Tech Support is whether you can read or retrieve a JSON file using the HTTP protocol on the INFILE statement. Or, Tech Support may have some other ideas of how to read the JSON file without using the XML Mapper. The key to using the XML Mapper is that you have XML to read with it -- since JSON bills itself as NOT XML -- I just don't see how that's going to help you. If you are working with the BI Platform, it looks like the BI Web Services do have some interaction with JSON: http://support.sas.com/documentation/cdl/en/wbsvcdg/62759/HTML/default/viewer.htm#n0uxdl0ugxduw6n1gduq1rcbo7i5.htm To me that indicates you ought to work with Tech Support before you reinvent the wheel. cynthia
... View more