Thank you, Reeza. I was confused about what I was asking for. Participant Month1 Month2 Month3 Month4 1 8 1 . 9 2 . . 3 15 3 4 5 . 12 4 1 . . 10 I want to be able to count the number of participants in each month and the change in participants each month. Here is my first attempt at this: proc sql; select count(*) as Total, count(month1) as Month_1, count(month2) as Month_2, count(month3) as Month_3, count(month4) as Month_4 from work.charity; quit; Output: Total Month_1 Month_2 Month_3 Month_4 4 3 2 1 4 This works to count individual columns but not the intersection of two months. The intersection will illustrate how many from one month continued on to the next month. Is it possible to specify this within the count statement?
... View more