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
How to zoom in a part of the kdensity graph?Hi, I would like to zoom in the left tail of a kdensity graph. I would like to show clearly the dif…
asdoc with Chinese labelDear All, How can I output the correlation matrix into Word with a "Chinese" label using (ssc instal…
Customizing value labels with encode or related commandsHello: I am trying to encode str var into an encoded var_code, which is typically a simple command..…
Word scores when people add or drop forenames, while keeping at least twoI've been matching entire electoral rolls in Stata 16. My sixth joinby is on first forename, surname…
import csv delimiter problem, strings squeeze togetherDear Statalists, When I use: Code: import delimited using x.csv, clear delim(",") varn(nonames) …
Subscribe to:
Post Comments (Atom)
0 Response to How do I identify a variable within a date interval
Post a Comment