Cynthia, Thanks. I want to put format in perticular OBS. Like you understad excactly what I want to say. But thing is I have both character columns. But like I have different OBS in ABC column. ABC CDE Russia 20,000 Russia_PCT 4% US 45,000 US_PCT 9% Total 500,000 Like this. And I want to put thousand seperator in Numbers and Percent in relative record. And I am using SAS EG 4 and MS Excel 2003.... Or can I use this way? ** code snippet; ods tagsets.excelxp file='c:\temp\use_call_define.xml' style=sasweb options(doc ='Help'); proc report data=testdata nowd; title 'Using CALL DEFINE'; Column grp abc cde; define grp / order; Define abc/ display style(column)={just=l}; DEFINE cde/ display style(column)={just=l}; compute cde; if abc = 'Russia' or 'US' or 'Total' then do; call define(_col_,'format','Comma9.'); call define(_col_,'style','style={tagattr="###,###,###"}'); end; else if abc = 'Russia_PCT' or 'US_PCT' then do; call define(_col_,'format','Percent9.2'); call define(_col_,'style','style={tagattr="###%"}'); end; endcomp; run; ods _all_ close; Thanks.
... View more