## Categorize

Solved
Super Contributor
Posts: 713

# Categorize

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

Accepted Solutions
Solution
‎04-17-2015 11:41 AM
Valued Guide
Posts: 863

## Re: Categorize

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;

All Replies
Posts: 3,001

--
Paige Miller
Posts: 1,147

## Re: Categorize

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

Thanks,
Jag
Solution
‎04-17-2015 11:41 AM
Valued Guide
Posts: 863

## Re: Categorize

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;

🔒 This topic is solved and locked.