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
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
I doubt proc export has any notion of what an escape character is.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.