I have the Employee List and front of them have the city where they belong, I want to give the Customers to these employees based on category which i have created.
Table 1. So i have the Employee , city , and the count of customers needed from the category ( Two category 1 & 2)
Table 2. I have Customers and City and Category in next table.
I want to extract the Customers and want to give to the employee
I have mention the category wise count which is needed
Please help
Output needed :-
CUSTOMER NAME , CITY , CATEGORY , EMPLOYEE NAME
Attacing the Excel file for the same
Is this different than the question you've posted in Base Programming?
Please post sample data in your question, not as an attachment or image.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.