BookmarkSubscribeRSS Feed
krishnaboosireddi
Calcite | Level 5

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

1 REPLY 1
Cynthia_sas
SAS Super FREQ

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;

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 949 views
  • 0 likes
  • 2 in conversation