Not sure exactly what you are looking for as a result. It it something like this?
data have;
infile datalines dsd dlm='|' truncover;
input ID YEAR season:$6. time_of_day:$7. species affected dead;
datalines;
1|2010|spring|night|3|5|0
2|2010|summer|morning|1|0|1
3|2010|autumn|day|2|1|1
4|2010|winter|morning|1|3|1
5|2011|spring|morning|2|0|1
6|2011|autumn|night|3|2|5
7|2011|summer|day|1|1|1
8|2011|winter|morning|1|3|1
;
proc means data=have sum maxdec=0;
var species affected dead;
class year;
run;
proc means data=have sum maxdec=0;
var species affected dead;
class season;
run;
proc means data=have sum maxdec=0;
var species affected dead;
class time_of_day;
run;
YEAR
N Obs
Variable
Sum
2010
4
species
affected
dead
7
9
3
2011
4
species
affected
dead
7
6
8
season
N Obs
Variable
Sum
autumn
2
species
affected
dead
5
3
6
spring
2
species
affected
dead
5
5
1
summer
2
species
affected
dead
2
1
2
winter
2
species
affected
dead
2
6
2
time_of_day
N Obs
Variable
Sum
day
2
species
affected
dead
3
2
2
morning
4
species
affected
dead
5
6
4
night
2
species
affected
dead
6
7
5
... View more