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
Data set is empty.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.