Hi,
I want a total this way If it's possible in the middle
Thank's
data AA;
infile datalines dlm=',';
input Stn1 $ stn2 $ stn3 $ stn4 $ avg1 avg2 avg3 avg4;
datalines;
NE,CC,A1,Z2,11111,11111,11110,5555
NE,CC,A1,Z2,11111,11111,11110,5555
NE,SS,A2,N5,11111,11111,11110,5555
TT,HH,QQ,T4,22222,11119,22223,2322
TT,HH,OO,M1,33333,33333,33331,2309
SE,ZZ,KK,P6,44444,44444,44444,1100
;
run;
ods excel file='c:\temp\x.xlsx' ;
proc report data=AA nowd style(header)=header{background=$back. foreground=$fore.};
column Stn1 stn2 stn3 stn4 avg1 avg2 avg3 avg4 ;
define stn1 / order ;
define stn2 / order ;
define stn3 / order ;
define stn4 / order;
define avg1 /analysis;
define avg2 / analysis;
define avg3 / analysis;
define avg4 / analysis;
break after stn1 / summarize ;
compute after stn1;
stn1='GLOBAL';
line ' ' ;
call define(_row_,'style','style=[ background=white ]');
endcomp;
/* FIN CALCUL DES TOTAUX */
run;
ods excel close;
run;
ods excel close;
... View more
