Hi! Thanks for your reply. This works perfectly, but then I noticed that in my data exists couple of subjects (my data consist 20 000 rows) who has obs like this 7 1994 1 1 3 4 4 4 So now those rows become 7 1994 1 1 3 2 3 3 And what I want them to become is 7 1994 1 1 3 2 2 2 Didin't realize when asking the question that there might be also obs like this.. (So that there would be some kind of logic why I want create rows like this, is that those numbers indicate subjects marital status in year(1 to 5). So that 1=single 2=married 3=child and this number 4 is married & child. And I want separate that value. If subject has value 4 after being single, then it should be first married and then child (that's how it done right now). But if subject has first child and then has a value number 4 then it should be coded that first child(=3) then married(=2).)
... View more