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):
Revenue $21,000
Salaries $56,896.56
Expenses $17,724.42
RBREAK Summary $95,620.98
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.
Trying to achieve:
Revenue $21,000
Salaries $56,896.56
RBREAK Summary $35,896.56
Thanks for your help,
Jason Browning
Controller
Lake Superior State University
|
|
0
|
|
|
|
Reply
|
Jason
|
10/20/2010 3:02:05 PM |
|