reshape long error variable not found but the variable exists

[Carolina Vargas]

RESOLVED: FOUND THE ERROR IN THE CODE. I WROTE THE VARIABLE TWICE. SORRY TRIED TO DELETE IT BUT COULD NOT.

Dear all,

Im working with a data set that has information by state on the number of criminal events by type of event (26 types of events) and years (1997-2022). The data set looks a little like this

ID	number_year1_1997	number_year2_1997	…	number_year26_1997	…	number_year7_2022	…	number_year26_2022
1	0	0	…	0	…	0	…	1
2	1	0	…	12	…	0	…	0
3	0	0	…	0	…	0	…	4

I want to reshape it from wide to long so that the years are in a single column.

I used the following command:

reshape long number_year1_ number_year2_ number_year3_
number_year5_ number_year6_ number_year7_ number_year7_ number_year8_
number_year9_ number_year10_ number_year11_ number_year12_
number_year13_ number_year14_ number_year15_ number_year16_
number_year17_ number_year18_ number_year19_ number_year20_
number_year21_ number_year22_ number_year23_ number_year24_ number_year25_, i(state_lga) j(year)

but I get the following error:

reshape long number_year1_ number_year2_ number_year3_ number_year5_ number_year6_ number_year7_ number_year7_ number_year8_ number_year9_ number_year10_ number_year11_ numbe
> r_year12_ number_year13_ number_year14_ number_year15_ number_year16_ number_year17_ number_year18_ number_year19_ number_year20_ number_year21_ number_year22_ number_year23_
> number_year24_ number_year25_, i(state_lga) j(year)

(j = 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022)
variable number_year7_1997 not found

But variable number_year7_1997 exists:

Can anyone help? Thank you

[Hemanshu Kumar]

In your command, you have number_year7_ entered twice. Remove one of them and try running your command again?