How to output Greek letters in Excel file

[JohnChen_TW]

Hi all, 

I'm having an issue that I'd like to display the Greek letters in excel output, but it cannot work with ods escapechar="^"; Why?

The following is my code.

ods escapechar="^";
%let a=^{unicode 03B2};

data want;
length x $20;
x="&a";
run;

proc export data = want
   outfile ="~path\result.xls"
   dbms = excel replace;
run;

It's always shown as ^{unicode 03B2} in excel file...but it can work properly when outputs as RTF file...why?

ods escapechar="^";
%let a=^{unicode 03B2};

data test;
length x $20;
x="&a";
run;

proc print data=test; run;
ods listing close;
ods rtf file="~path\report.rtf";
proc report data = test nowindows;
    title &a;
    define x/"name &a" width=20;
run;
ods rtf close;
ods listing;

Does anyone have the suggestion?

Thank you!

JC

[art297]

It will work if you use ods excel. e.g.:

ods excel file="/folders/myfolders/testit.xls" ;
proc print data=want noobs;
run;
ods excel close;

Art, CEO, AnalystFinder.com

[JohnChen_TW]

It seems unable to work in SAS 9.3...

[JohnChen_TW]

Does anyone know why the Greek letters cannot be displayed properly when using proc export to convert an excel file?

[ChrisNZ]

I doubt proc export has any notion of what an escape character is.