Hi, I am a beginner in Stata. recently I spent a lot of day in creating a panel data, I have a huge dataset, part of my data looks like that, it includes the starting year and the ending year, but I need a year variable, still don't know how to create a year variable
clear
input long group id float(min_year max_year)...(some other variables)
1 109 2015 2018
1 109 2015 2018
2 234 2005 2007
2 234 2005 2007
2 234 2005 2007
3 240 2008 2009
3 252 2010 2012
end
[/CODE]
I want the data looks like that,it will be unbalanced panel data
clear
input long id float(min_year max_year) Year...(some other variables)
1 109 2015 2018 2015
1 109 2015 2018 2016
1 109 2015 2018 2017
1 109 2015 2018 2018
2 234 2005 2007 2005
2 234 2005 2007 2006
2 234 2005 2007 2007
3 240 2008 2009 2008
3 240 2008 2009 2009
3 252 2010 2012 2010
4 252 2010 2012 2011
4 252 2010 2012 2012
end
[/CODE]
many thanks!!!
Related Posts with automatically creating year variable for panel data
Interflex graph region whiteHi, does anybody know if there is a way to change the background colour from light blue to white wit…
standard error double lasso with clusteringHi, I am using the new cluster feature for LASSO in stata and I am a little confused by the way the…
Histogram formattingHello, I am trying to format the x axis of a histogram with a specific range. I want to have a bmi …
Difference in difference Post and Treatment dummiesI want to apply a difference in difference estimations to observe differences in the dependent varia…
opreg with IfHi Profs and Colleagues, I wonder if there is any difference between these two codes #1 & #2. I…
Subscribe to:
Post Comments (Atom)
0 Response to automatically creating year variable for panel data
Post a Comment