How to expand a panel data for countries for 5 years for each period (2005-2009, 2010-2014,2017-2022)

[Saleh sharmah]

Dear members

I have country-level data from three periods ( 2005-2009, 2010-2014, and 2017-2022). I would like to use the 2005-2009 period data for the year 2005,2006,2007,2008,2009 and the same goes for the other periods for each country.


* Example generated by -dataex-. For more info, type help dataex
clear
input int Year str8 Country float id str8(A071 A071B A088 A088B A103 A197 B001)
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Inactive" "A little" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Somewhat" "Strongly"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Strongly"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Somewhat" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Inactive" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Active m" "Somewhat" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Strongly"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Disagree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Active m" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Like me" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "Very muc" "Agree"
2005 "Andorra" 2 "Not aske" "Not aske" "Not aske" "Not aske" "Not a me" "A little" "Agr

what are the correct codes to do it.

thank you for your kind help.

[Clyde Schechter]

gen `c(obs_t)' obs_no = _n
expand 5
by obs_no, sort: replace Year = Year[1] + _n - 1
isid obs_no Year, sort

[Saleh sharmah]

Thank you so much Clyde for your helpful response.