Counting unique products for a list of members

[JDonovan]

Hello. 

I have a dataset that has the following set up.

member_id sold_dt product

1  xx/xx/xxxx a

1  xx/xx/xxxx b

1  xx/xx/xxxx b

1  xx/xx/xxxx c

2 xx/xx/xxxx a

2 xx/xx/xxxx a

2 xx/xx/xxxx a

2 xx/xx/xxxx b

What I want to do is end up with a dataset with the following set up:

member_id product_cnt

1 3

2 2

I want a count of the unique products.

J

[novinosrin · Accepted solution]

data have;
input (member_id sold_dt product) (:$20.);
datalines;
1  xx/xx/xxxx a
1  xx/xx/xxxx b
1  xx/xx/xxxx b
1  xx/xx/xxxx c
2 xx/xx/xxxx a
2 xx/xx/xxxx a
2 xx/xx/xxxx a
2 xx/xx/xxxx b
;

proc sql;
create table want as
select member_id, count(distinct product) as count
from have
group by member_id;
quit;