topic Re: Extracting the Count based on Conditions in SAS Programming

Extracting the Count based on Conditions

ramesh31 — Mon, 27 Jun 2016 06:19:06 GMT

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).

Re: Extracting the Count based on Conditions

Ksharp — Mon, 27 Jun 2016 06:56:22 GMT

So what kind of output would you like to see ?

Re: Extracting the Count based on Conditions

Kurt_Bremser — Mon, 27 Jun 2016 06:56:59 GMT

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.

Re: Extracting the Count based on Conditions

ramesh31 — Mon, 27 Jun 2016 07:01:46 GMT

I would like to see the CUSTOMER , CATEGORY , EMP

Re: Extracting the Count based on Conditions

ramesh31 — Mon, 27 Jun 2016 07:05:56 GMT

RESULT REQUIRED

CATEGORY OF CUSTOMER

BASE DATA

EMP

Re: Extracting the Count based on Conditions

ramesh31 — Mon, 27 Jun 2016 07:34:15 GMT

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

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

Re: Extracting the Count based on Conditions

Ksharp — Mon, 27 Jun 2016 07:41:50 GMT

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

Re: Extracting the Count based on Conditions

Ksharp — Mon, 27 Jun 2016 07:49:30 GMT

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 .