Hi, I have a dataset with some accounts and every account may have more than one observation in the data. Assuming a scenarion, if one of the account has 10 observations and every observation has a different stat_code which is one of the variables along with stat_dt What i want to do is to go through the first entry till the last entry of the duplicate accounts and then apply a condition on stat_code, something like if substr(stat_code, 4,1) = 'S' and every time it finds that between the first and the last observation, it outputs that entry into a seperate dataset. Will appreciate some direction and help! --Tej
... View more