Categorize

[SASPhile]

  A product can have three categories 'X','Y','Z'.
   Now if a customer has all three product X,Y,Z or X Y or X Z then he should be categorized as having X
     if he has Y or Z then he shouuld be categorized as Y
       if only Z then categoried as having only Z
      
Customer    product     category
A                      X            X
A                      Y        
A                      Z
B                      Y            Y
B                      Z
C                     X            X
C                     Z       
D                     Z            Z

[PaigeMiller]

What is your question?

[Jagadishkatam]

Please try

data have;

input Customer$    product$     ;

cards;

A                      X    

A                      Y    

A                      Z

B                      Y    

B                      Z

C                     X     

C                     Z     

D                     Z     

;

proc transpose data=have out=want;

by customer;

var product;

run;

data want2;

merge have want;

by customer;

if first.customer and cats(of col:) in ('XYZ','XY','XZ') then category='X';

if first.customer and cats(of col:)='YZ' then category='Y';

if first.customer and cats(of col:)='Z' then category='Z';

drop _name_ col:;

run;

Thanks,

Jag

[Steelers_In_DC · Accepted solution]

I think this is what you are looking for but without a question it's hard to tell:

data have;

infile cards dsd;

input Customer $ product $;

cards;

A,X

A,Y

A,Z

B,Y

B,Z

C,X

C,Z

D,Z

;

run;

proc sql;

create table want as

select *,min(product) as category

from have

group by customer;