DATA Step, Macro, Functions and more

How to output Greek letters in Excel file

Reply
Contributor
Posts: 56

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,363

Re: How to output Greek letters in Excel file

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

 

Contributor
Posts: 56

Re: How to output Greek letters in Excel file

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

Re: How to output Greek letters in Excel file

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

Re: How to output Greek letters in Excel file

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

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