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
Clustering standard errorsI have a cross-sectional dataset at the firm level, and my interest variable (RHS) is a country-leve…
String Variable - Subinstr? Regex?Dear Statalist, I am in the process of cleaning a dataset, in particular standardizing a string vari…
date conversionA bit new to Stata. Wondered if someone could tell me how to convert a date variable from an externa…
trade structural gravity equation; instruments; ppmlhdfeI work with trade data: 75 importers, 75 exporters; 2004-2018 period, six-digit HS Industries (5219)…
Error of sample contain multiple panels: Panel data with multiple identifiersI am attempting to obtain the autocorrelations and partial autocorrelations and to perform the Dicke…
Subscribe to:
Post Comments (Atom)
0 Response to recoding a new generated variable
Post a Comment