How to read an XML with unicode?

JohnChen_TW — Mon, 05 Aug 2019 04:04:25 GMT

Hi Everyone,

I'm trying to import an XML with unicode to SAS 9.3, and below is my program.

FILENAME XMLIMP "C:\Users\john.chen\Desktop\test.xml";
LIBNAME XMLIMP XML XMLTYPE=CDISCODM;
%MACRO ALLSETS(LIB);
PROC SQL NOPRINT;
SELECT UNIQUE MEMNAME INTO :DSETS SEPARATED BY '|'
FROM DICTIONARY.TABLES
WHERE UPCASE(LIBNAME)="&LIB";
%PUT DATASETS: &DSETS;
QUIT;
%LET NUM=1;
%LET DSET=%SCAN(%QUOTE(&DSETS),&NUM,|);
%DO %UNTIL (%QUOTE(&DSET)=%STR());
DATA WORK.&DSET; SET XMLIMP.&DSET; RUN;

%LET NUM=%EVAL(&NUM+1);
%LET DSET=%SCAN(%QUOTE(&DSETS),&NUM,|);
%END;

%MEND ALLSETS;
%ALLSETS(XMLIMP);

When the dataset (test.XML) has an unicode, like ≥, I will get below error message:

Line 6421 is:

How can I read it correctly?

Thanks!

Re: How to read an XML with unicode?

Ksharp — Mon, 05 Aug 2019 12:10:27 GMT

Is your sas encoding UTF-8 ?

and also Try :

FILENAME XMLIMP "C:\Users\john.chen\Desktop\test.xml" encoding='utf-8' ;

topic Re: How to read an XML with unicode? in SAS Programming

How to read an XML with unicode?

Re: How to read an XML with unicode?