SAS creating af tabel with SQL statement which shows number of cases

I'm struggeling with creating a tabel in SAS using proc sql which summerizes numbers of confirmed cases with a disease. I need different tabel for age, sex and number of cases pr. week.

I already imported the variables from SQL to SAS