Help using Base SAS procedures

Simple Count

Reply
Contributor
Posts: 60

Simple Count

Hi

Looking to perform a simple count.


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

Frequent Contributor
Posts: 95

Re: Simple Count

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;

Regular Contributor
Posts: 151

Re: Simple Count

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;

Ask a Question
Discussion stats
  • 2 replies
  • 215 views
  • 0 likes
  • 3 in conversation