Extracting the Count based on several Conditions

ramesh31 — Mon, 27 Jun 2016 05:18:06 GMT

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

Re: Extracting the Count based on several Conditions

Reeza — Mon, 27 Jun 2016 06:50:24 GMT

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.

topic Re: Extracting the Count based on several Conditions in SAS Enterprise Guide

Extracting the Count based on several Conditions

Re: Extracting the Count based on several Conditions