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
How to random sample individual from the householdDear stata users I'm currently working on the data which consists of households. Individuals in the…
Import delimited - not all observations importedI have a .txt file with 18 variables and 1,368,958 observations/lines with piping as a delimiter (|,…
Where are user-written graph schemes stored (after installing them)?Where are user-written graph schemes stored (after installing them)? I installed the cleanplots sche…
sem estat teffects and mi estimateI created a SEM model after mi impute the missing values, and when I applied estat teffects to the m…
Standardizing vs normalizing independent variablesHi, I need help with the following: In my dataset, I have two independent variables A and B. A is t…
Subscribe to:
Post Comments (Atom)
0 Response to Variable assigning number to dates within periods
Post a Comment