SAS VISUALIZATION - Value distribution in percentage

mihirparmar23 — Sun, 21 Jul 2024 06:51:10 GMT

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.

topic SAS VISUALIZATION - Value distribution in percentage in SAS Visual Analytics

SAS VISUALIZATION - Value distribution in percentage