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;
I don't think you can do this directly.
You probably have to process the XML file after creation. See here.
I don't think you can do this directly.
You probably have to process the XML file after creation. See here.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.