Good day SAS programmers,
I have what must be a simple formatting issue. I am attempting to
prepare a flash financial statement using SAS from our Oracle
database. I have the data fine, but in PROC REPORT, it adds the
revenues and expenses together - for example (the break is on account
type):
Fund A Fund B Fund C
Sales $15,000 $4,000 $10,000
Service $6,000 $11,000 -$4,000
Revenue $21,000 $15,000 $6,000
Administrative $20,000 $15,000 --
Professional $36,896 $10,000 $5,000
Salaries $56,896.56 $25,000 $5,000
Coffee $17,724 $5,000 $1,000
Supplies -- $5,000 $2,333
Expenses $17,724.42 $10,000 $3,333
RBREAK Summary $95,620.98 $50,000 $14,333
I want to subtract expenses from revenue for the summary line. Is
there an easy way, or a compute block method, to do this? I have
eight columns for different funds, and am generating ODS PDF output.
I can make it work if I make my expenses negative, but I want them to
show as positive on the financial statement.
For example, on the above, I want the following result on the left column of values:
Revenue $21,000
Salaries $56,896.56
RBREAK Summary $35,896.56
I would like to know if I can accomplish this in PROC REPORT, or if I need to conduct further data pre-processing, etc. (It seems more appropriate for PROC COMPUTAB, but that is not present in our Base 9.3.1 install.) Thanks for your help,
Will try not to bother the forum in the future -- after Googling for two days, I'm out of ideas, which makes me think it's a simple oversight...
Jason Browning
Controller
Lake Superior State University