Extracting the Count based on Conditions

[ramesh31]

Hii, Please help , I have BASE DATA in which I have category-wise Customers I want to give the Customers to each employee based on category, (which I have mentioned the Count) - RESULT REQUIRED TABLE There should not be duplicate of customers Example :- Emp 1 want 27 customer from category A so , pull or extract the Customers from BASE DATA table category A ,So after the extraction the count remaining should be ( 8000-27 = 7973) , for EMP 2 , We want 21 from A category so pull out customers form BASE DATA category A (7973).

[Ksharp]

So what kind of output would you like to see ?

[ramesh31]

I would like to see the CUSTOMER , CATEGORY , EMP

[Ksharp]

NO. I mean the result table as you showed in your EXCEL .

[ramesh31]

I have attached the file for the data ( Sheet - DATA)

So, Form base data, I wanted to extract the Customers.

[Ksharp]

What is your rules? How can you get RESULT REQUIRE from BASE DATA ? Where is EMP NAME coming from ? BASE DATA don't have it .

[Kurt_Bremser]

Please supply your example data in a data step with cards;

I won't open a MS Office file from the web because of security considerations. I guess the same goes for most contributors here.

[ramesh31]

	RESULT REQUIRED
	CATEGORY OF CUSTOMER					BASE DATA
EMP	A	B	C	D					CATEGORY	COUNT OF TOTAL CUSTOMERS
1	27	30	18	29					A	8000
2	21	18	17	21					B	12000
3	10	18	10	28					C	9000
4	13	24	24	17					D	11000
5	23	12	18	29
6	13	29	13	26
7	27	11	23	18
8	16	16	27	16
9	25	13	20	27
10	13	26	25	28
11	24	12	14	29
12	12	20	25	22
13	14	12	24	26
14	28	22	20	27
15	30	27	30	13
16	12	25	18	21
17	13	13	15	17
18	17	18	14	28
19	11	25	12	20