Hi ,
How to set the font size in line statement while reporting in excel i.e. using ods tagsets.excelxp?
I used font_size=10pt and font=(Arial,10pt) in style's any of this didn't work.
The below is the code how i used :
compute before <variable>/style={font=(Arial,10pt) font_weight=bold just=l};
length myline $85;
myline=<variable>;
line myline $ 85.;
endcomp;
compute before <variable>/style={font_size=10pt font_face=Arial font_weight=bold just=l};
length myline $85;
myline=<variable>;
line myline $ 85.;
endcomp;
just=l is working and the remaining is not working.
Can you guys please help me out with this?
Thanks,
Reddi krishna
Hi:
I find that concrete code always helps. When I run this code (below) I see a color of cyan and a font of 14pt Arial, bold. (Using SAS 9.3, Excel 2010 and either TAGSETS.EXCELXP or MSOFFICE2K.
cynthia
ods tagsets.excelxp file='c:\temp\tryxp.xml' style=sasweb;
ods msoffice2k file = 'c:\temp\trymso.xls' style=sasweb;
proc report data=sashelp.class nowd;
column age name height weight;
define age / order;
compute before age/
style={font_size=14pt font_face=Arial foreground=cyan
font_weight=bold just=l};
length myline $85;
myline='This is a test string for: '||put(age,2.0);
line myline $85.;
endcomp;
run;
ods _all_ close;
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.