Checking repetition by column

[Nishant_saxena]

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

[stat_sas]

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;

[Astounding]

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;