I am having trouble creating an efficient way to use PROC SQL in SAS to gather monthly data for 4 years (2017, 2018, 2019, through now of 2020).

My current (shortened) code:

```
PROC SQL;
select 
count(VAL1) as name1, sum(VAL2) as name2
from table  tbl
WHERE tbl.dte  >= '20170101' and tbl.dte < '20170201'
); 

```

I am currently just using a copy and paste method over and over, but I would need to do this over a hundred times, for four tables (equaling to about 500 times).

Is there a more efficient way to do this?