Hello, I'm trying to use a simple aggregate function, aim is to find all codes where count(acct)=0. I'm wondering what is the correct way to use this, I've tried a couple of variations- assigned count with a variable name, made the where clause as null etc. proc sql;
create table abc12 as
select tcd, count(acct) From check
where count(acct) = " " group by tcd;
quit; And the error I keep getting is: ERROR: An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference. Appreciate the help! Sample Data - what I have : tcd acct
980 2243003
665 345
105 32245030
665 58603230
105 32249531
651
221 6032264901
221 265379
720
980 75660 what I'm looking for: tcd count(acct)
980 2
665 2
105 2
651 0
221 2
720 0 and then from this table I want to extract all tcd values that have count(acct)=0
... View more