PROC REPORT

[VISHNU239]

Hi, I need a code to the below attached file scenario. I need to calculate total paid to john and total paid to monty separately by adding rows  and in the end I want to calculate total paid to both by adding both  sum columns in the proc report. I am using enterprise guide.

[RW9]

Thats likely why you are employed to do it.  This is a Q&A board, not a contract work.  Also, when posting a question, provide test data in the form of a datastep, what the output should look like, and explain any working.  

Sums can be done in many ways, 

datastep

proc sql

proc means/summary

Once you have teh data for your output you would then use proc report to display the data in the pdf, using some compute blocks to add blank lines.