Hi Miller, Below is my sas code with some changes from the suggestions. The total is still blank. Yes. My code defined stat to character type. But I am not sure how to fix it. Can you please suggest a solution? proc means data=ds0 sum stackodsoutput;
class var1;
var tot_phys_ov_cnt tot_ov_pts tot_hv_pts tot_all_phys_cnt tot_all_pts_cnt;
ods output summary=ds1(drop=_:);
run;
data colfmt;
set ds1;
by var1 notsorted;
keep fmtname start label;
fmtname = 'anagrpnfmt';
if first.var1 then do;
start = var1;
label = cats(put(var1, anagrpnfmt.),'~(N=', put(nobs, comma5.0), ')');
output;
end;
run;
proc format cntlin=colfmt;
run;
data ds1;
set ds1;
by var1 notsorted;
label = compress(label, '|');
if first.var1 then idx = 0;
idx + 1;
length stat $32;
if not missing(sum)
then stat = strip(put(sum, 12.0));
run;
ods results=off;
filename fout '/c/test.xls';
ods excel file=fout options(embedded_titles='yes') style=Excel;
ods excel options(sheet_name='Table9' absolute_column_width='21' flow='tables' frozen_headers='3');
title j=left h=13pt 'test';
ods listing close;
proc report data=ds1 split='~';
column idx label (var1, stat) n;
define idx / noprint group;
define label / '' group left;
define var1 / '' across nozero order=internal format=anagrpnfmt.;
define stat / '' center;
define n/computed f=comma18.0 "ALL Combined";
compute n;
n=sum(stat);
endcomp;
run;
ods excel close;
filename fout clear;
title;
ods results;
... View more