Dear Statalist,
I have a dataset extracted from real-life patient journals over a 10 year period. Each row has a time-stamp (YMDHHMMSS), patient identifier and either a column with laboratory value or prescription. Prescriptions and laboratory values are in separate collumns and each value are on a separate row. In all there are apr 100.000 rows of which 25.000 are laboratory and 75.000 are prescriptions. I want to study what laboratory value has preceded change in medication. For this I need to tag prescriptions that are closest in time after a laboratory value. Can someone please help me?
I have a dataset extracted from real-life patient journals over a 10 year period. Each row has a time-stamp (YMDHHMMSS), patient identifier and either a column with laboratory value or prescription. Prescriptions and laboratory values are in separate collumns and each value are on a separate row. In all there are apr 100.000 rows of which 25.000 are laboratory and 75.000 are prescriptions. I want to study what laboratory value has preceded change in medication. For this I need to tag prescriptions that are closest in time after a laboratory value. Can someone please help me?
Comment