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;
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 ............;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.