Hi.
I have a dataset where I have registered observations on specific dates within a different periods from start_date to end_date.
I want to generate a variable that counts "on what day the event occurred" within my periods.
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input float id long event float(date_of_event start_date end_date)
11 1 1.870004e+12 1.867075e+12 1.870589e+12
11 3 1.8681838e+12 1.867075e+12 1.870589e+12
11 2 1.869392e+12 1.867075e+12 1.870589e+12
13 2 1.8693916e+12 1.867075e+12 1.870589e+12
13 1 1.869403e+12 1.867075e+12 1.870589e+12
16 2 1.870447e+12 1.867075e+12 1.870589e+12
16 1 1.8692985e+12 1.867075e+12 1.870589e+12
17 2 1.870551e+12 1.867075e+12 1.870589e+12
17 2 1.8705503e+12 1.867075e+12 1.870589e+12
19 2 1.870559e+12 1.867075e+12 1.870589e+12
end
format %tc date_of_event
format %tc start_date
format %tc end_date
In this example there is only one period but my dataset contains several different periods.
So in order to compare timing of events across different periods I need a variable that counts the first day in the period as days 1, the second day as day 2, etc.
Time is not important (for this) and does not need to be accounted for in the new variable.
Hope you can help me.
Kind regards
Related Posts with Variable assigning number to dates within periods
Probit model with fixed effectsDear all, I am estimating a probit model with individual-level data on sickness and district-level …
Prevalence with multiple variablesHello, I am analyzing a hospital dataset which provides demographic, diagnostic, and procedural data…
Bar Graph with multiples variables and categoriesHi, everyone! I need to perform a bar graph with 2 variables containing 4 categories each. The 2 var…
Problems with Panel Data AnalysisHello everyone, I'm dealing with panel data analysis and still confused about few things I have a t…
Remove gaps between the y-axis first or last ticks and horizontal frames of a box plotHi Stata box plot experts; I am sketching a box plot using Stata. These are my codes for y-axis lab…
Subscribe to:
Post Comments (Atom)
0 Response to Variable assigning number to dates within periods
Post a Comment