I have a dataset with ACCNO as a variable. we need to grab all the observations with ACCNOs with COUNT 3 or more .(or to create a new dataset with COUNT 3 or more) I was thinking to implement this logic using first and last temporary variables but it was giving error. When it will read the first observation of any individual account number then initialize n=0 and increment each iterating time and when it will read last observation of any individual account then if value of n greator than or equal to 3 the it should Create a new dataset satisfying this condition. Can there be any better logic for this .as below logic not working data ssingh.FINADVNEWariable set ssingh.FINADV by ACCNO; if first.ACCNO then n = 0; n + 1; if last.ACCNO and n gt 3 then output ; run; Please reply
... View more