Besides, the 'Note:xxxxx' is the data out of table cells, how can I adjust its font-style by 'proc template; ....; replace fonts/ ...;'? JC
... View more
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
... View more
My question is, I cannot know the format of each variable from the external files in advance. After googled, I just know that the format will be saved in sashelp.columns. But it will not save the format with the number when the actual format is $SEXOF6.. 1. What does the number of formats mean? 2. How to get the complete format from the external files in advance?
... View more
As far as I know, all items and attributes for features in dataset would be automatically saved in SASHELP. And I need to use PUT function to create a new variable in the macro. So, I tried to retrieve the variable format (e.g. $SEXOF6.) from SASHELP but it just recorded the char part as "$SEXOF.". Why? Does anyone have a suggestion to retrieve the complete format?
... View more
Yes, as @Astounding said, the program works if removed the quotes. Many thanks for your explanation and provide. You have added to my knowledge. But why "%let ty=x;" can avoid error message? what kind of error message? JC
... View more
Before creating table detect, there was a DATA PROCESS to put the external dataset in WORK named as X. However, that will be time-consuming to check the variable types one by one when there are too many datasets, Also, when I put the dataset in WORK, sashelp.Vcolumn has recorded all types of the variables from each dataset. So, I think I shoud do PROC SQL to get the type of the variable and save it as a macro variable first, and then do PROC MEANS/PROC FREQ under the condition as %if (type is num/char) %then...%do. JC
... View more
Sorry, please see the following full code. %macro test(have,var);
proc sql;
create table detect as select type
from sashelp.column
where libname='WORK' and name="&var";
quit;
data _null_; set detect;
call symputx('ty',type);
run;
%if &ty='num' %then %do;
proc means data=&have;
var=&var;
run;
%end;
%mend;
%test(x,y);
... View more
%let var=x;
proc sql;
create table detect as select type
from Sashelp.Vcolumn
where libname='WORK' and name="&Var.";
quit;
%if &fm='num' %then %do;
.
.
.
%end; Above is a part of my macro program. I am not sure why the condition (%if...%then %do) cannot work...
... View more
