Data.. Dataset xyz; Input ID$ month checking expense; Data lines; X 2020/9 300 100 X. 2020/10 400 . X 2020/11 . 60 Y 2020/9 400 . Y 2020/10 200 50 Z 2020/19 . . ; Run; Result should be like this.. ID Monthsnum Average_ check averageexlense X 3 350 80 Y 2 300 50 Z 1 . . Any help would be greatly appreciated. I am beginner to sas programming. Proc sql is not allowed to use. Thank you!!!
... View more
