topic Re: Counting unique products for a list of members in SAS Programming

Counting unique products for a list of members

JDonovan — Fri, 02 Feb 2018 20:28:44 GMT

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 c

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.

Re: Counting unique products for a list of members

novinosrin — Fri, 02 Feb 2018 20:36:47 GMT

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;