DATA Step, Macro, Functions and more

Counting unique products for a list of members

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Counting unique products for a list of members

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


Accepted Solutions
Solution
‎02-02-2018 04:23 PM
PROC Star
Posts: 1,592

Re: Counting unique products for a list of members

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;

View solution in original post


All Replies
Solution
‎02-02-2018 04:23 PM
PROC Star
Posts: 1,592

Re: Counting unique products for a list of members

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 91 views
  • 0 likes
  • 2 in conversation