Hi everyone,
A sample of my data looks as follows (my current data ). As you can see, the person 1's starting health status (health_1) is H (healthy) in 2000 then becomes U (unhealthy) in 2002 and again H (healthy) in 2004. I would like to generate a new health variable (e.g., health_2) that reads that person's health status in 2000 as U which equals his/her health status in 2002 and so one. Additionally, If the person dies then the health_2 is U rather than missing.
Thanks,
Nader
*My current data
clear all
input id year str6 (health_1)
1 2000 "H"
1 2002 "U"
1 2004 "H"
2 2000 "H"
2 2002 "H"
3 2000 "H"
3 2002 "H"
3 2004 "H"
end
list
*My goal
clear all
input id year str6 (health_1 health_2)
1 2000 "H" "U"
1 2002 "U" "H"
1 2004 "H" "."
2 2000 "H" "H"
2 2002 "H" "."
3 2000 "H" "H"
3 2002 "H" "H"
3 2004 "H" "."
end
list
Related Posts with recoding a new generated variable
Graph optionsArray Dear Stata users, I am wondering is it possible to control the size of the second label (num…
ICD 10 Codes dataset: Please helpHi there, Please I urgently need help with generate new variable consisting ICD 10 codes related to…
checking string similarity within the same variableDear all, This message was initially posted in the discussion thread HTML Code: https://www.stata…
Delta method toHello I am using stata 14 and the mixlogit command (user install) to analyse data from a discrete c…
Suppressing dummy variables in regression output tableHello! I have run a regression which contains several dummy variables which I would like to exclude…
Subscribe to:
Post Comments (Atom)
0 Response to recoding a new generated variable
Post a Comment