HI,
So I have panel data for 5 years (4,5,6,7,8) and I am evaluating a policy change that happened just after year 6. So now my pre-policy years are 4 and 5 and post-policy years are 6,7,8. I am trying to categories the individual (id) into non-users, pre and post-policy based on when they used a particular service (x, where x is is a dummy variable x=1 if they used the service, zero otherwise) please see the following example
id year x
1 4 1 ( id 1 is a pre- policy user)
1 5 0
1 6 1
2 4 0
2 5 0
2 6 1 ( id 2 is a post-policy user)
3 4 1
3 6 1 (id 3 is a pre policy user)
4 4 .
4 7 1 (id 4 is a post policy user)
5 4 0
5 5 0
5 6 0
5 7 0
6 7 0
7 8 0 ( id 5- 7 ) all non-users. Thanks
So if an individual uses the service in all the years they are still considered pre-policy users. They are only considered post-policy users if they use the service only in year 6, 7, or 8
Can anyone help as to how one does that? Thanks for your help in advance
Kind Regards,
Aarushi
Related Posts with Generating a variable for user pre and post policy change
Counting unique no missing valuesHi! My dataset is about trust in government and media. It contains two variables: 1. city- the code …
forval with a variableHello everyone. I am new to Stata. I need your help for a short question. I have a dataset, and I ho…
How to calculate effect size for Kruskal-Wallis test?Dear all, I am struggling to estimate the effect size for the Kruskal-Wallis test in Stata. I will b…
Human opportunity indexHi, I am trying to apply below mentioned HOI syntax on education data to check inequality of opportu…
Panel data: Calculate change within each subgroup from the first to the last observation (over time)Hi, I work on unbalanced panel data (26 states ("cant"), time period around 1970-2017) on wealth sh…
Subscribe to:
Post Comments (Atom)
0 Response to Generating a variable for user pre and post policy change
Post a Comment