Hi all, first of, I apologize if this question should be asked in another board. I generated a .map file from an XML. I would them read (SELECT) from an xml file to generate tabular data. The XML files contain a deep structure, i.e., they are not tabular. PROBLEM: when reading the xml with the generated map, the key columns are always missing. 1) Here is an extract from the .map file (table "acts"): <!-- ############################################################ -->
<TABLE description="acts" name="acts">
<TABLE-PATH syntax="XPathENR">/{1}corpcan/blablas/blabla/acts</TABLE-PATH>
<COLUMN class="ORDINAL" name="blabla_ORDINAL">
<INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}corpcan/blablas/blabla</INCREMENT-PATH>
<TYPE>numeric</TYPE>
<DATATYPE>integer</DATATYPE>
</COLUMN>
<COLUMN class="ORDINAL" name="acts_ORDINAL">
<INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}corpcan/blablas/blabla/acts</INCREMENT-PATH>
<TYPE>numeric</TYPE>
<DATATYPE>integer</DATATYPE>
</COLUMN>
</TABLE>
<!-- ############################################################ --> 2) Here is an extract of the script used to read the xml: filename myfile '<PATH_TO_FILE_XML>\<XML_FILE_001>.xml';
filename SXLEMAP '<.MAP_FILE GENERATED BY XML MAPPER>';
libname myfile xmlv2 xmlmap=SXLEMAP access=READONLY; 3) Here is the output of the Acts table after reading from the xml. The xml file contains lots of data and these values should not be missing. There should be no missing value at all. Other détails: SO: Win 7 Enterprise guide: 7.100.2856 Platform version: 9.4.0.0 XML mapper: 903000.0 Does anyone know what could be wrong that SAS is not generating the auto-increment values? has anyone faced a similar issue? Thanks in advance!
... View more
