BookmarkSubscribeRSS Feed
cm2
Calcite | Level 5 cm2
Calcite | Level 5

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;

1 REPLY 1
Ksharp
Super User

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 ............;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1067 views
  • 0 likes
  • 2 in conversation