Problem Note 36830: The %MDUEXTR bulkload macro fails with an XML processing error when you use non-English encoding
 |  |  |  |
When you execute the %MDUEXTR macro in a non-English encoded version of SAS®, an XML processing failure might occur and produce errors similar to the following:
MPRINT(MDUEXTR): LIBNAME _metpinf XML xmlmap=_USERMAP access=READONLY;
NOTE: Libref _METPINF was successfully assigned as follows:
Engine: XML
Physical Name: _METPINF
MPRINT(MDUEXTR): proc sql;
SYMBOLGEN: Macro variable LIBREF resolves to MDEXTR
MPRINT(MDUEXTR): create table MDEXTR.person_info as select * from _metpinf.person;
MPRINT(MDUEXTR): * FROM PERSON IN FILE '';
ERROR: Der Name enthält ein unzulässiges Zeichen.
encountered during XMLMap parsing
occurred at or near line 5, column 4
ERROR: XML describe error: Internal processing error.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
SYMBOLGEN: Macro variable LIBREF resolves to MDEXTR
NOTE: Statement not executed due to NOEXEC option.
MPRINT(MDUEXTR): create index id on MDEXTR.person_info(id) quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The PROCEDURE SQL used 0.01 CPU seconds and 29848K.
Error such as this can occur when the encoding for a language is not designated in the XML file.
Typically the XML code is created by a DATA step.
To circumvent this issue, you must update the %MDUMAP and %MDUADMS macros that create XML maps in the sasprefix.AUTOLIB library to include the correct encoding. For example, update all occurrences of <?xml version="1.0" ?> as shown in the following example, where nnnn matches the last four characters of your encoding:
Encoding values are based on the following table:
German W3 1141 Danish W5 1142 Swedish W6 1143 Finnish W6 1143 Italian W7 1144 French WA 1147
For example, the edited text for Finnish (W6) would read as follows:
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | z/OS | 9.2 TS2M0 | |
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-10-06 13:48:18 |
| Date Created: | 2009-08-12 16:22:46 |