XML Map: Showing element tags when value is missing

ADN — Mon, 05 Nov 2018 07:44:34 GMT

I am using XMLV2 engine to export SAS datasets to xml. The issue is when a numeric value is missing. By default SAS shows

<column_name>.</column_name>. If I set options missing="" then I get only <column_name />.

Is there any way to show <column_name></column_name> without the dot for numeric missing values when using xmlmap.

Sample Code is given below:

libname lib1 xmlv2 "/data/sample.xml" xmlmap="/data/sample_data.map";



data lib1.abcd;

set temp;/*Dataset containing 10 numeric and 10 character columns*/

run;

Re: XML Map: Showing element tags when value is missing

ChrisNZ — Tue, 06 Nov 2018 22:18:14 GMT

I don't think you can do this directly.

You probably have to process the XML file after creation. See here.

topic XML Map: Showing element tags when value is missing in SAS Programming

XML Map: Showing element tags when value is missing

Re: XML Map: Showing element tags when value is missing