Dear SAS Users, I have this below table.   Old Account Number New Account Number Date 1   20180630 1 2 20180731 2 3 20180731 3 4 20180731 4 5 20180731   Table contains both old and new account numbers. New account numbers gets assigned whenever old gets transferred. I want to select all those records where particular account transferred atleast 4 times in given month. In above example I want to select all the rows from 2 for 20180731. I tried using self joins but unfortunately it didn't work. I found most difficult part is extracting only count of transfer ge 4.   I will really appreciate your help.   Thanks in advance!   ... View more