Hi there,

I need to recode variables for specific cases:
I have 2 obs for each individual (Case_ID=552) but I only have info about income in one them, like below (present data). I would like to replicate income in each case (desired data). Is there a script to do this?

thanks in advance

Present data desired data
CASE_ID BID_inc CASE_ID BID_inc
1 0 1 1000
1 1000 1 1000
2 0 2 100
2 100 2 100
3 0 3 1000
3 1000 3 1000
4 0 4 100
4 100 4 100
5 0 5 80
5 80 5 80
6 0 6 400
6 400 6 400
7 0 7 400
7 400 7 400
8 0 8 2000
8 2000 8 2000
… … … …