Hi all,    I have a big dataset (cows data) and I would like to know how many herds in each county in each month.   my data looks like this;     data example; datelines; county herd month London 11 Jan London 11 Jan London 11 Jan London 11 Jan London 11 Jan London 12 Fed London 11 Fed London 12 Fed London 11 Fed London 12 Fed London 12 Fed London 11 Mar London 12 Mar London 13 Mar London 11 Mar London 12 Mar London 14 Mar   And what I need to count the frequency of herd in each month by county and the results should be like this; county     month     number of herds  London    Jan       1 Herd London    Feb       2 herds London     Mar      4 herds    So, I need a code to count frequencies of herds for each month in each county.   What My code should look like?   best regards    Ibrahim        ... View more

  Hi all, I have created this code in order to keep at least 5 cow_id for each herd per year.  this code working perfectly across all years,    what I need,  How to specify my requirement per year not across all years?     data have has these three variables   cow_id,  herd and year.    Regards    proc sql; create table herdcount as select * from have where herd in (select distinct herd from have group by herd having count(distinct cow_id) >= 5); run;quit; ... View more