Counting dataset entries by two different variables

sasDave — Wed, 11 Nov 2020 22:40:24 GMT

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;

Re: Counting dataset entries by two different variables

PaigeMiller — Wed, 11 Nov 2020 22:45:43 GMT

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

topic Counting dataset entries by two different variables in SAS Programming

Counting dataset entries by two different variables

Re: Counting dataset entries by two different variables