SAS 9.4 I have a dataset of car crashes in Texas for each county and each month (each entry is a crash). I want to count each entry for each county/month combo to get the monthly crash total per county. So far I've tried PROC SQL and it mixed counties or months depending on how I set it up. There are 254 counties in Texas so using specific if functions is an unappealing option as well. This is the PROC SQL function I tried proc sql
create table count as
select
county,
sum(val=1) as count_var
from Rawdata
group by month_code
quit;
run;
... View more
