Hi, Please help me find the solution. I have data like this. id day1 day2 day3 day4 day5 day6 day7 day8 day9 day10.. 1 . . 3 . . 6 . 8 . . 2 . . . 4 . . 7 . . 10 3 1 2 . . . . . . . . 4 1 . 3 . . . 7 . . . 5 . . . . 5 . . . . . I want to pull out values not missing.. like this, id var1 var2 var3 var4 var5 ... 1 3 6 8 . . 2 4 7 10 . . 3 1 2 . . . 4 1 3 7 . . 5 5 . . . . day variables are over 2000, observations are over 500000. Can anyone help me? Thanks! 😄
... View more