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.
... View more