I am a fisheries biologist and am new to programming and SAS but would like to become more proficient at this.  One analysis that we use often is Catch Per Unit of Effort (CPUE) for each species for numerous different efforts (time).  I am having trouble figuring out how to add zero catches.     As you can see it is pretty simple calculation CPUE= # fish caught in each species / minutes. However, as you can see below in effort(barcodeID) A1234 a sauger was caught, but in B1234 and C1234 one was not caught.  So when we calculate a mean CPUE of all the runs together the zero catches need to be included into the analysis. I need some help with developing code to include a catch of zero for each effort(barcodeID) and species when it is not present in the data.  I would also like to calculate CPUE based on different sized fish as well.  So CPUE of Walleye and Sauger <200 and CPUE of Walleye and Sauger >200.   Hopefully that is clear enough. Thanks in advance!   Here is how my data is set up: BarcodeID       Date                Minutes        Species      Length   A1234             5/15/2020         15.00          Walleye        180 A1234             5/15/2020         15.00          Walleye        350 A1234             5/15/2020         15.00          Sauger         175 B1234             5/15/2020         15.00          Walleye        400 B1234             5/15/2020         15.00          Walleye        500 C1234             5/15/2020         15.00          NoFish           .            ... View more