@Patrick @Kurt_Bremser
Hi,
Any idea how I can get the missing observation where highlighted in seq variable 5&6, but it should not retain the values in seq 8 and 9 of my orignal post.
I tried to use retain statement but it does not provide the output I want.
I am sharing another example below - I only want collap, count, collapse where highlighted in yellow. The reason behind is because I have collapsed dates where collapex =Y . All the dates associated with the collapsing should have collap = 1, count =1 or count =2 if a second collapsing of date has happened within same subject and collapse = Y.
Hope this is clear. Apart from retain what is the best method I can use?
... View more