<?xml version="1.0" encoding="UTF-8"?>
<Test>
<Set>
<Header>
<dataset formaat="v1" status="production" naam="needthisoutputfromsas.xml"/>
<date>12-10-2016</date>
<source>mycompany</source>
</Header>
<Record>
<Birthdate pattern="dd-MM-yyyy">21-10-1945</Birthdate>
<Gender>V</Gender>
<Postalcode>1234</Postalcode>
<Data>
<Key>1</Key>
</Data>
</Record>
<Record>
<Birthdate pattern="dd-MM-yyyy">11-02-1963</Birthdate>
<Gender>V</Gender>
<Postalcode>4321</Postalcode>
<Data>
<Key>2</Key>
</Data>
</Record>
<Record>
<Birthdate pattern="dd-MM-yyyy">26-05-1978</Birthdate>
<Gender>V</Gender>
<Postalcode>2345</Postalcode>
<Data>
<Key>3</Key>
</Data>
</Record>
</Set>
</Test> Hello, I hope someone can help me generating a correct .map for export my sas dataset into the above.xml example. The auto_gen function in sas XML mapper makes all these tables, but I can ouput only one, right? <?xml version="1.0" encoding="UTF-8"?>
<!-- ############################################################ -->
<!-- 2016-11-29T21:53:10 -->
<!-- SAS XML Libname Engine Map -->
<!-- Generated by XML Mapper, 904000.0.0.20130522190000_v940 -->
<!-- ############################################################ -->
<!-- ### Validation report ### -->
<!-- ############################################################ -->
<!-- XMLMap validation completed successfully. -->
<!-- ############################################################ -->
<SXLEMAP name="Test" version="2.1">
<!-- ############################################################ -->
<OUTPUT>
<HEADING>
<ATTRIBUTE name="description" value=""/>
</HEADING>
<TABLEREF name="Record"/>
</OUTPUT>
<NAMESPACES count="0"/>
<!-- ############################################################ -->
<TABLE name="Record">
<TABLE-PATH syntax="XPath">/Test/Set/Record</TABLE-PATH>
<COLUMN name="Birthdate">
<PATH syntax="XPath">/Test/Set/Record/Birthdate</PATH>
<TYPE>numeric</TYPE>
<DATATYPE>date</DATATYPE>
<FORMAT width="10">IS8601DA</FORMAT>
<INFORMAT width="10">IS8601DA</INFORMAT>
</COLUMN>
<COLUMN name="Gender">
<PATH syntax="XPath">/Test/Set/Record/Gender</PATH>
<TYPE>character</TYPE>
<DATATYPE>string</DATATYPE>
<LENGTH>1</LENGTH>
</COLUMN>
<COLUMN name="Postalcode">
<PATH syntax="XPath">/Test/Set/Record/Postalcode</PATH>
<TYPE>numeric</TYPE>
<DATATYPE>integer</DATATYPE>
</COLUMN>
<COLUMN name="Key">
<PATH syntax="XPath">/Test/Set/Record/Data/Key</PATH>
<TYPE>numeric</TYPE>
<DATATYPE>integer</DATATYPE>
</COLUMN>
</TABLE>
</SXLEMAP> Thanks in advance, Brendy Wauben /********************************************************************************
* Generated by XML Mapper, 904000.0.0.20130522190000_v940
********************************************************************************/
filename client 'C:\mysas\needthisoutputfromsas.xml';
filename SXLEMAP 'C:\mysas\out.map';
libname client xmlv2 xmlmap=SXLEMAP ;*access=READONLY;
libname out "C:\mysas\out";
* local files;
data client.Record;
set out.mydataset ;
run;
... View more