topic Re: How to set the font size in line statement while reporting in excel i.e. using ods tagsets.excelxp? in ODS and Base Reporting

How to set the font size in line statement while reporting in excel i.e. using ods tagsets.excelxp?

krishnaboosireddi — Mon, 15 Apr 2013 14:24:17 GMT

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

Re: How to set the font size in line statement while reporting in excel i.e. using ods tagsets.excelxp?

Cynthia_sas — Mon, 15 Apr 2013 18:16:24 GMT

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;