I have a dataset which needs to be summarized using PROC SQL. Below is the sample data: Location Name Bank Amount DEL A0BC PNB 5000 DEL A1BC SBI 6000 DEL A2BC PNB 4000 DEL A3BC SBI 2000 DEL A4BC PNB 6000 DEL A5BC SBI 7000 MUM A4BC SBI 5000 MUM A5BC SBI 7000 MUM A6BC PNB 8000 MUM A7BC PNB 9000 MUM A8BC SBI 8000 MUM A9BC PNB 5000 BAN A8BC SBI 4000 BAN A9BC PNB 3000 BAN A10BC PNB 7000 BAN A11BC SBI 6000 BAN A12BC PNB 5000 BAN A13BC SBI 8000 How can i summarize it to get the top two clients identified by location based on Total volume and bank share? Kindly guide me to get my output as below: Location PNB SBI Total %PNB %SBI DEL 6000 7000 13000 46% 54% DEL 5000 6000 11000 45% 55% MUM 9000 8000 17000 53% 47% MUM 8000 7000 15000 53% 47% BAN 7000 6000 13000 54% 46% BAN 5000 5000 10000 50% 50% Update: I have attached DS with the desired out sheet. Airlines to be clubbed in 2 groups. Group1. Jet Airways and Air India Group2. Others To identify top 15 clients location wise based upon the total volume and airline group share.
... View more
