HI,
Would someone be able to help me with a code for how to identify a viable within a date interval. In short I have a dataset in which I I have an exposure date (injury date) and outcome which is sickness absence. I look at new sickness absence cases and identify them by register data from one one, in which I can see the first day of the sickness absence spell (SAstart) and the last day of the spell (SAend). Each person in the dataset can have multiple sickness absence spells starting within a given time period. So far all good. However, I would like to create a variable which states which of the sickness spells is on the day of the injury, eg for ID 1 it might be SAstart5, for ID2 it might be SAstart5 aso. Since we have data for the whole year it is not given that the persons first sickness absence is in relation to the exposure, they can have had a sickness absence spell before the injury during that year as well. the data is in wide format att he moment.
persons are identified by ID
then each person has variables injury date1, SAstart1 (to SAstart225, however only few persons have that many), SAend1 (to 225).
So, how do I identify which one of the spells does the exposure occur?
grateful for any assistance.
Related Posts with How do I identify a variable within a date interval
Asymptomatic/Finite Sample analysisThis may not be the forum for this- perhaps Cross- Validated, but I don't have a Stata question as m…
reshape errorDear Stata users, I am facing problem with -reshape wide- command. More specifically, I would like …
Removing Leading and Trailing SpacesConsider the following full worked example Code: import delimited "http://qed.econ.queensu.ca/jae/d…
Fixed effect model for hospital and patietn level data (really need some help)Hi, I am exploring a dataset of patient data from 20 hospitals for 3 years. Among which 9 hospitals…
Error when run heatplot with "function drop() not declared in class ColrSpace (120 lines skipped) " Code: ssc install heatplot Code: ssc install palettes, replace Code: ssc install colrspace, repla…
Subscribe to:
Post Comments (Atom)
0 Response to How do I identify a variable within a date interval
Post a Comment