DATA Step, Macro, Functions and more

How to output Greek letters in Excel file

Reply
Frequent Contributor
Posts: 75

How to output Greek letters in Excel file

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

 

PROC Star
Posts: 7,489

Re: How to output Greek letters in Excel file

Posted in reply to JohnChen_TW

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

 

Frequent Contributor
Posts: 75

Re: How to output Greek letters in Excel file

It seems unable to work in SAS 9.3...
Frequent Contributor
Posts: 75

Re: How to output Greek letters in Excel file

Posted in reply to JohnChen_TW
Does anyone know why the Greek letters cannot be displayed properly when using proc export to convert an excel file?
PROC Star
Posts: 1,760

Re: How to output Greek letters in Excel file

Posted in reply to JohnChen_TW

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

Ask a Question
Discussion stats
  • 4 replies
  • 175 views
  • 0 likes
  • 3 in conversation