PROC REPORT Totals

  • Follow


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


0 Replies
430 Views

(page loaded in 0.016 seconds)

Similiar Articles:













7/23/2012 8:49:42 PM


Reply: