topic Re: Categorize in SAS Programming

Categorize

SASPhile — Fri, 17 Apr 2015 14:55:17 GMT

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

Re: Categorize

PaigeMiller — Fri, 17 Apr 2015 15:15:29 GMT

What is your question?

Re: Categorize

Jagadishkatam — Fri, 17 Apr 2015 15:34:34 GMT

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

Re: Categorize

Steelers_In_DC — Fri, 17 Apr 2015 15:41:08 GMT

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;