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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.