Creating a table using Proc tabulate?

Mirisage — Wed, 13 Feb 2013 22:34:42 GMT

Hi SAS Forum,

Could anyone help me to create the below table using the attached SAS data set?

cur_arrears
prev_arreras	Data	60 - 90	Current	Not Exi	NPNA	Grand Total
1 - 30	Count of Account_number	1				1
	Sum of prev_bal	900				900
	Sum of cur_bal	800				800
60 - 90	Count of Account_number			1		1
	Sum of prev_bal			800		800
	Sum of cur_bal
90 +	Count of Account_number			1		1
	Sum of prev_bal			3000		3000
	Sum of cur_bal
Current	Count of Account_number		1	1		2
	Sum of prev_bal		999	666		1665
	Sum of cur_bal		666			666
Not Exi	Count of Account_number				2	2
	Sum of prev_bal
	Sum of cur_bal				45	45
NPNA	Count of Account_number			2	1	3
	Sum of prev_bal			52	25	77
	Sum of cur_bal				32	32
Total Count of Account_number		1	1	5	3	10
Total Sum of prev_bal		900	999	4518	25	6442
Total Sum of cur_bal		800	666		77	1543

Actually I have generated this table using Excel Pivot approach.

However, my original dataset that I have created using SAS has more than 300, 000 records, and our Excel 2003 cannot handle it to create a pivot table.

I have to present this table tomorrow morning meeting and I cannot so far make a try even.

I really appreciate your help.

Thanks

Mirisage

Re: Creating a table using Proc tabulate?

ballardw — Thu, 14 Feb 2013 15:27:41 GMT

Data set is empty.

topic Creating a table using Proc tabulate? in SAS Procedures

Creating a table using Proc tabulate?

Re: Creating a table using Proc tabulate?