Dear Team,
Please help to resolve the below issue related to sas visualization.
Say by I have below table in excel and want to create the same in sas visualization. Then how to do the same.
My SAS data has 2 products personal loan and home loan (A) disbursed for 2 month and their channel disbursement distribution in CRORES (B) & PERCENTAGE (%) as shown below. This is called a KPI (Key performance indicator).
PORTFOLIO SNAPSHOT (PERSONAL LOAN) | Dec-23 | Jan-24 |
A - PERSONAL LOAN (DISBURSED in Crs) | 60 | 100 |
B - ONLINE | OFFLINE (DISTRIBUTION IN CR) | 30|30 | 60|40 |
C - ONLINE | OFFLINE (DISTRIBUTION%) | 50%|50% | 60%|40% |
PORTFOLIO SNAPSHOT (HOME LOAN) | Dec-23 | Jan-24 |
A - HOME LOAN (DISBURSED in Crs) | 600 | 1000 |
B - ONLINE | OFFLINE (DISTRIBUTION IN CR) | 30|30 | 600|400 |
C - ONLINE | OFFLINE (DISTRIBUTION%) | 50%|50% | 60%|40% |
My requirement is to develop a query in sas visualization calculated field so that I can get above C point (ONLINE | OFFLINE (DISTRIBUTION%) with concatenation (|) while applying filter of home loan or personal loan respectively.
