Counting dataset entries by two different variables

[sasDave]

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;

[PaigeMiller · Accepted solution]

proc freq data=rawdata;
    tables county*month/list;
run;