Please excuse a SQL newbie question but I've searched and haven't found the answer I need. I'm trying to count the occurences where 3 things are true using the code below: proc sql; create table rates as select distinct time, start, end, hsp_id, hsp_state_code, type, count(input(hsp_id,7.)=&id. and input(nexthsp_id,7.)=&id. and readm30=1) as Numerator2 format=comma., count(input(hsp_id,7.)=&id.) as Denominator2 format=comma., calculated Numerator/calculated Denominator as pct format=percent8.3 from readmabase group by hsp_id, time order by hsp_state_code, hsp_id, time; quit; I'm trying to count where both hsp_id and nexthsp_id (character variables) equal &id. (a given hospital ID) and readm30 = 1 (numeric variable). When I run the code, Numerator2 and Denominator2 are always the same. Thanks for any help!
... View more