Hi,
I have excel file of intermediary code who does insurance business and want to give commission as per their business amount, location, product, channel, make and model.
I have already made query for individual intermediary code basis of if condition and it’s working fine.
Now, list is increased by 2000 records and very difficult to right individual query to each intermediary code. I am trying through CATX function which is also not manageable after certain limit as combination is being increased day by day.
I want to learn dynamic query. Please share any demonstration video and inform about it.
Also, sharing an example SAS table for your reference.
IMD_Code | Location | Product | Make | Model | Business | Channel | Commission % |
1234 | | | | | | | 10 |
1235 | Mumbai | | | | | | 5 |
1236 | Pune | Pvt | | | | | 7 |
1237 | Delhi | Pvt | Maruti | Alto | | | 12 |
1238 | Delhi | Pvt | Maruti | All | > 100000 | | 19.5 |
1239 | Mumbai | Pvt | | | | Motor PC | 19.5 |
1240 | Mumbai | Tw | | | | Motor TW | 22.5 |