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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.