Hi,
My dataset has both 'year' and 'month' information for some variables. I want to generate a 'financial year' variable consisting of months April of this year to March of next year. Dataex is given below:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int year str9 month str14 state str35 description float(fy fy1)
2015 "April"     "Karnataka" "Egg"    201516 201819
2015 "May"       "Karnataka" "Egg"    201516 201819
2015 "June"      "Karnataka" "Egg"    201516 201819
2015 "July"      "Karnataka" "Egg"    201516 201819
2015 "August"    "Karnataka" "Egg"    201516 201819
2015 "September" "Karnataka" "Egg"    201516 201819
2015 "October"   "Karnataka" "Egg"    201516 201819
2015 "November"  "Karnataka" "Egg"    201516 201819
2015 "December"  "Karnataka" "Egg"    201516 201819
2016 "January"   "Karnataka" "Egg"    201516 201819
2016 "February"  "Karnataka" "Egg"    201516 201819
2016 "March"     "Karnataka" "Egg"    201516 201819
2016 "April"     "Karnataka" "Egg"    201617 201819
2016 "May"       "Karnataka" "Egg"    201617 201819
2016 "June"      "Karnataka" "Egg"    201617 201819
2016 "July"      "Karnataka" "Egg"    201617 201819
2016 "August"    "Karnataka" "Egg"    201617 201819
2016 "September" "Karnataka" "Egg"    201617 201819
2016 "October"   "Karnataka" "Egg"    201617 201819
2016 "November"  "Karnataka" "Egg"    201617 201819
2016 "December"  "Karnataka" "Egg"    201617 201819
2017 "January"   "Karnataka" "Egg"    201617 201819
2017 "February"  "Karnataka" "Egg"    201617 201819
2017 "March"     "Karnataka" "Egg"    201617 201819
2017 "April"     "Karnataka" "Egg"    201718 201819
2017 "May"       "Karnataka" "Egg"    201718 201819
2017 "June"      "Karnataka" "Egg"    201718 201819
2017 "July"      "Karnataka" "Egg"    201718 201819
2017 "August"    "Karnataka" "Egg"    201718 201819
2017 "September" "Karnataka" "Egg"    201718 201819
2017 "October"   "Karnataka" "Egg"    201718 201819
2017 "November"  "Karnataka" "Egg"    201718 201819
2017 "December"  "Karnataka" "Egg"    201718 201819
2018 "January"   "Karnataka" "Egg"    201718 201819
2018 "February"  "Karnataka" "Egg"    201718 201819
2018 "March"     "Karnataka" "Egg"    201718 201819
2018 "April"     "Karnataka" "Egg"    201819 201819
2018 "May"       "Karnataka" "Egg"    201819 201819
2018 "June"      "Karnataka" "Egg"    201819 201819
2018 "July"      "Karnataka" "Egg"    201819 201819
2018 "August"    "Karnataka" "Egg"    201819 201819
2018 "September" "Karnataka" "Egg"    201819 201819
2018 "October"   "Karnataka" "Egg"    201819 201819
2018 "November"  "Karnataka" "Egg"    201819 201819
2018 "December"  "Karnataka" "Egg"    201819 201819
2019 "January"   "Karnataka" "Egg"    201819 201819
2019 "February"  "Karnataka" "Egg"    201819 201819
2019 "March"     "Karnataka" "Egg"    201819 201819
2015 "April"     "Karnataka" "Fruits" 201516 201819
2015 "May"       "Karnataka" "Fruits" 201516 201819
2015 "June"      "Karnataka" "Fruits" 201516 201819
2015 "July"      "Karnataka" "Fruits" 201516 201819
2015 "August"    "Karnataka" "Fruits" 201516 201819
2015 "September" "Karnataka" "Fruits" 201516 201819
2015 "October"   "Karnataka" "Fruits" 201516 201819
2015 "November"  "Karnataka" "Fruits" 201516 201819
2015 "December"  "Karnataka" "Fruits" 201516 201819
2016 "January"   "Karnataka" "Fruits" 201516 201819
2016 "February"  "Karnataka" "Fruits" 201516 201819
2016 "March"     "Karnataka" "Fruits" 201516 201819
2016 "April"     "Karnataka" "Fruits" 201617 201819
2016 "May"       "Karnataka" "Fruits" 201617 201819
2016 "June"      "Karnataka" "Fruits" 201617 201819
2016 "July"      "Karnataka" "Fruits" 201617 201819
2016 "August"    "Karnataka" "Fruits" 201617 201819
2016 "September" "Karnataka" "Fruits" 201617 201819
2016 "October"   "Karnataka" "Fruits" 201617 201819
2016 "November"  "Karnataka" "Fruits" 201617 201819
2016 "December"  "Karnataka" "Fruits" 201617 201819
2017 "January"   "Karnataka" "Fruits" 201617 201819
2017 "February"  "Karnataka" "Fruits" 201617 201819
2017 "March"     "Karnataka" "Fruits" 201617 201819
2017 "April"     "Karnataka" "Fruits" 201718 201819
2017 "May"       "Karnataka" "Fruits" 201718 201819
2017 "June"      "Karnataka" "Fruits" 201718 201819
2017 "July"      "Karnataka" "Fruits" 201718 201819
2017 "August"    "Karnataka" "Fruits" 201718 201819
2017 "September" "Karnataka" "Fruits" 201718 201819
2017 "October"   "Karnataka" "Fruits" 201718 201819
2017 "November"  "Karnataka" "Fruits" 201718 201819
2017 "December"  "Karnataka" "Fruits" 201718 201819
2018 "January"   "Karnataka" "Fruits" 201718 201819
2018 "February"  "Karnataka" "Fruits" 201718 201819
2018 "March"     "Karnataka" "Fruits" 201718 201819
2018 "April"     "Karnataka" "Fruits" 201819 201819
2018 "May"       "Karnataka" "Fruits" 201819 201819
2018 "June"      "Karnataka" "Fruits" 201819 201819
2018 "July"      "Karnataka" "Fruits" 201819 201819
2018 "August"    "Karnataka" "Fruits" 201819 201819
2018 "September" "Karnataka" "Fruits" 201819 201819
2018 "October"   "Karnataka" "Fruits" 201819 201819
2018 "November"  "Karnataka" "Fruits" 201819 201819
2018 "December"  "Karnataka" "Fruits" 201819 201819
2019 "January"   "Karnataka" "Fruits" 201819 201819
2019 "February"  "Karnataka" "Fruits" 201819 201819
2019 "March"     "Karnataka" "Fruits" 201819 201819
end
In the above dataset, "fy" is the variable I am trying to generate.
I used the following code:
Code:
local months1 "April May June July August September October November December"
local months2 "January February March"

gen fy1=0
foreach fn_yr in 201516 201617 201718 201819{
forval yr1 = 2015/2018{
forval yr2 = 2016/2019{
foreach x1 of local months1{
foreach x2 of local months2{
replace fy1=`fn_yr' if year==`yr1' & month=="`x1'" | year==`yr2' & month=="`x2'"
}
}
}
}
}
This gives the variable "fy1" which is NOT the same as "fy". It only assigns the last financial year in the dataset: 201819. Don't know how to create the variable "fy". Any help will be greatly appreciated.
Thank you!