DATA Step, Macro, Functions and more

Checking repetition by column

Reply
Occasional Contributor
Posts: 11

Checking repetition by column

Hi guys,

I'm stuck on a very simple n small problem and note able to form the logic.

Please help me out.

 

sample dataset is:

 

store_id          configuration         store_name

1                             1                          A

2                             2                          A

3                              2                         B

4                             1                          C

5                              2                         C

6                             1                          D

 

I want to know if all stores sell all configurations or not ??

Please help me.

Thanks

Trusted Advisor
Posts: 1,204

Re: Checking repetition by column

Hi,

 

If you have only two configurations then following code will give you stores selling all of them

 

proc sql;
select store_name,count from (
select *,count(distinct configuration) as count from have
group by store_name)
where count=2;
quit;

Super User
Posts: 5,071

Re: Checking repetition by column

Based on your data, it's difficult to tell what "all stores" means.  Is it every STORE_ID?  Every STORE_NAME?  Assuming it's every STORE_NAME, here's one way to get a report:

 

proc freq data=have;

tables store_name * configuration / norow nopercent nocol;

run;

Ask a Question
Discussion stats
  • 2 replies
  • 73 views
  • 0 likes
  • 3 in conversation