How to I write a SAS dataset to XML with Japanese data?

cm2 — Tue, 20 Jun 2017 15:42:47 GMT

Hi, I have a SAS dataset with Japanese characters in the result field. I need to export this to xml. When I run the code the xml file has errors and does not open. The csv file opens but the Japanese is all garbbled. I tried the option locale=ja_JP, but that didn't seem to work. Is there another option that I need to use? Thanks for your help!!

result visit

死んでしまいたいと思った。死んでしまいたいと思った。 1

死んでしまいたいと思った。死んでしまいたいと思った。 2

ods _all_ close;

options orientation=landscape nodate center missing=" " nonumber locale=ja_JP;

ods tagsets.ExcelXP file="p:\Trans.xml";

title ;

ods tagsets.ExcelXP options(sheet_name="Translated_Records");

proc report data=temp.qs_raw nowindows headline headskip split='^' spacing=1 list MISSING

style(header)=[background=white font_weight=bold font_size=8pt just=left cellpadding=2]

style(column)=[background=white just=center vjust=bottom cellwidth=1in font_size=8pt];

columns result visit;

define result /display order=data "Result" style=[cellwidth=1in just=left font_weight=bold];

define visit /display order=data "Visit" style=[cellwidth=1in just=left font_weight=bold];

run;

PROC EXPORT DATA= WORK.Qs_raw

OUTFILE= "p:\Free_Text_Fields.csv"

DBMS=CSV REPLACE;

PUTNAMES=YES;

RUN;

ods tagsets.ExcelXP close;

Re: How to I write a SAS dataset to XML with Japanese data?

Ksharp — Wed, 21 Jun 2017 13:33:22 GMT

That is really odd. If your sas session is Japanese encoding, should be no problem.

or try this one .

filename x "p:\Trans.xml" encoding='utf8';

ods tagsets.ExcelXP file=x ............;

topic Re: How to I write a SAS dataset to XML with Japanese data? in SAS Programming

How to I write a SAS dataset to XML with Japanese data?

Re: How to I write a SAS dataset to XML with Japanese data?