topic Re: Checking repetition by column in SAS Programming

Checking repetition by column

Nishant_saxena — Tue, 11 Jul 2017 15:52:51 GMT

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

Re: Checking repetition by column

stat_sas — Tue, 11 Jul 2017 16:02:11 GMT

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;

Re: Checking repetition by column

Astounding — Tue, 11 Jul 2017 16:26:22 GMT

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;