topic Re: Simple Count in SAS Procedures

Simple Count

spraynardz90 — Thu, 14 Jun 2012 08:34:51 GMT

Looking to perform a simple count.

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

Re: Simple Count

Alpay — Thu, 14 Jun 2012 08:53:47 GMT

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;

Re: Simple Count

Keith — Thu, 14 Jun 2012 08:55:31 GMT

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;