topic Re: How to output Greek letters in Excel file in SAS Programming

How to output Greek letters in Excel file

JohnChen_TW — Mon, 05 Jun 2017 10:24:26 GMT

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!

Re: How to output Greek letters in Excel file

art297 — Mon, 05 Jun 2017 14:57:17 GMT

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

Re: How to output Greek letters in Excel file

JohnChen_TW — Tue, 06 Jun 2017 02:28:48 GMT

It seems unable to work in SAS 9.3...

Re: How to output Greek letters in Excel file

JohnChen_TW — Tue, 06 Jun 2017 02:37:49 GMT

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

Re: How to output Greek letters in Excel file

ChrisNZ — Tue, 06 Jun 2017 05:09:32 GMT

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