Simple Count

[spraynardz90]

Hi

Looking to perform a simple count.

I have my code just want to see what everyone else uses to check im correct

[Alpay]

Use SUM function with your criteria as an inline indicator (0,1) in Proc SQL.

proc sql;

    create table y as

    select *,

    sum(DISTCD in ('5523','1213')) as cnt

    from x

    group by monthyear;

quit;

[Keith]

Just do a proc freq and merge the output table back on to the original.  I've used the coalesce function in the remerge query to put a 0 for any months where the codes 5523,1213 don't appear.

proc freq data=have (where=(codes in (5523,1213)) noprint;

table monthyear / out=want;

run;

proc sql;

create table have as select

a.*,

coalesce(b.count,0) as distcd

from have as a left join want as b on a.monthyear=b.monthyear;

quit;