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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: