I have multiple blood test results for single pregnancies and wish to select the blood test result that was taken closest to the date at which a condition was diagnosed for each pregnancy (and drop the other results)
Thus I have four variables: Pregnancy ID, date of result, result, date condition diagnosed, e.g.:
Pregnancy ID Date condition diagnosed Result Date of result
1001 01/02/2009 59 30/07/2009
1001 01/02/2009 72 02/02/2009
1001 01/02/2009 94 01/07/2007
1001 01/02/2009 10 01/01/2002
So in the example of PregnancyID 1001 above, I want to keep the result that is 72 and drop the other three.
How would I do this? When writing my syntax I also want to add the caveat that I only want to do this for pregnancies in which there are multiple results. I have already created variable dup so would want to add the condition 'if dup >=1' to the end of my syntax.
Thank you.
Related Posts with How to select the observation with a date that is closest to another date in STATA
Failed ramesy RESET testHi, Im fairly new to stata, i've just manually run a RESET test on my panel data and it failed. I u…
Help looping with levelsof and egen...I need to create a binary indicator (weightmedian_binary) based on whether that variable (weight) is…
Interpreting the results from Loneway commandHi, I was hoping someone could help me. I ran the command Loneway recycling acode Where recycling i…
mvprobitDear Statusers, I’m writing for a question on the package mvprobit. I’m estimating a mvprobit for 5 …
Advice on survival analysis setupHello everyone, I’m hoping to solicit some advice from those of you that are familiar with survival…
Subscribe to:
Post Comments (Atom)
0 Response to How to select the observation with a date that is closest to another date in STATA
Post a Comment