Combining separate columns in Summary Reports

MatthewDurieux — Fri, 02 Dec 2016 16:48:50 GMT

Hi there!

I am trying to create a report that includes all data for each subject row in the columns.

Currently, i have information for each subject in two separate reports (see first photo). Since the data has been summed up into SAS Reports I am having a hard time combining the original data. Is there any way i can add the Sum of Debits, Sum of Credits and Balance check from the first table to the right of the second table? Tables 1 and 2 are currently represented in SAS Report.

Table 1
	ACCOUNT_NUM_1	ACCOUNT_NUM_2	TOTAL SUM
BATCH_ID_1	Sum of Transactions	Sum of Transactions	Batch_Total Sum
BATCH_ID_2	Sum of Transactions	Sum of Transactions	Batch_Total Sum

Table 2
	TOTAL_DEBITS	TOTAL_CREDITS	BALANCE
BATCH_ID_1	Sum of Debits	Sum of Credits	0
BATCH_ID_2	Sum of Debits	Sum of Credits	0


Table 3 (end results)
	ACCOUNT_NUM_1	ACCOUNT_NUM_2	TOTAL_SUM	TOTAL_DEBITS	TOTAL_DEBITS	BALANCE
BATCH_ID_1	Sum of Transactions	Sum of Transactions	Batch_Transactions_Sum	Sum of Debits	Sum of Credits	0
BATCH_ID_2	Sum of Transactions	Sum of Transactions	Batch_Transactions_Sum	Sum of Debits	Sum of Credits	0

Re: Combining separate columns in Summary Reports

RW9 — Fri, 02 Dec 2016 17:04:17 GMT

This is one good reason to avoid doing data processing in proc report. Do all yor data processing before reporting it out, then your proc report simply reports a dataset.

You can get sums and such like quite easily using SQL, means/summary procedures, datasteps. Then if you need to, merge data together.

Re: Combining separate columns in Summary Reports

MatthewDurieux — Mon, 05 Dec 2016 16:10:44 GMT

Thanks RW9. I'm trying to do that but having trouble with copying some of the report functionality into SAS Code.

topic Re: Combining separate columns in Summary Reports in SAS Enterprise Guide

Combining separate columns in Summary Reports

Re: Combining separate columns in Summary Reports

Re: Combining separate columns in Summary Reports