Hello
Please help me with the following. Let's say that I have the following table:
http://img96.imageshack.us/img96/3591/datay.jpg
I use proc tabulate to create an HTML report:
PROC TABULATE data=data ; title "Title"; class month currency product
var Amount;
table (Month (all='Sum_year'))* (Currency (all='Sum'))* (Product (all='Sum')), Amount;
RUN;
I get the following output table
http://img4.imageshack.us/img4/7752/output1.png
As you can see, the "USD" only appears in some months. Is there a way not to print the "sum", where there are no "USD" lines in data-table (in example - month 2).
Is there a way not to print the products in the total sum?
To make it easier to understand, I have uploaded a picture of how I want my output to look like:
http://img232.imageshack.us/img232/7825/output2.png
What do I have to write in Proc tabulate-statement?
Thank you!
... View more