I've found the Options. It is calling nozero. define txt / across nozero ''
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2}; But I don't understand why I've got single rows instead sum of any Groups. The sum option has no effekt (define amount / sum). DATA temp; infile cards delimiter=',';
input subject name $ number currency $ loan $ txt $ amount;
CARDS;
68832,Alice,100240,usd,046200,Loro,175
68832,Alice,100250,eur,046200,Loro,150
68832,Alice,100240,usd,046300,Nostro,275
68832,Alice,100250,eur,046300,Nostro,250
68834,Thomas,100340,usd,046300,Nostro,250
68834,Thomas,100350,eur,046300,Nostro,225
68835,Thomas,100340,usd,046300,Nostro,250
68835,Thomas,100350,eur,046300,Nostro,225
;
RUN;
proc report data=WORK.temp
nowindows missing headline spanrows split='*'
;
column subject name number currency loan, txt, amount
;
define subject / group display 'subject '
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2};
define name / group display 'name'
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2};
define number / group display 'number'
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2};
define currency / group display 'currency'
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2};
define loan / across nozero ''
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2};
define txt / across nozero ''
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2};
define amount / sum 'Amount in OC'
style(header)={just=left BACKGROUND=#4F81BD}
style(column)={font_face=Arial font_size=2 TAGATTR='format:#,##0.00;[Red](#,##0.00);[Blue]0.00;'};
run;
PROC TABULATE
DATA=WORK.TEMP
;
VAR amount;
CLASS subject / ORDER=UNFORMATTED MISSING;
CLASS name / ORDER=UNFORMATTED MISSING;
CLASS number / ORDER=UNFORMATTED MISSING;
CLASS currency / ORDER=UNFORMATTED MISSING;
CLASS loan / ORDER=UNFORMATTED MISSING;
CLASS txt / ORDER=UNFORMATTED MISSING;
TABLE /* Zeilendimension */
subject*
name*
number*
currency,
/* Spaltendimension */
loan*
txt*
amount*
Sum ;
;
RUN;
... View more