Hi y'all, I'm trying to reshape a dataset that I have just imported in Stata, but I get the following error once I run the command reshape: variable _j takes on too many values.
Here you can find my commands for the do-file:
"clear
set maxvar 15000
cd "C:\Users\ACER\Downloads\THESIS\EX"
import excel using ME.xlsm, sheet("ME") cellrange(B1:TNJ253) firstrow clear
gen time =_n
reshape long ME, i(time)
rename _j stock"
I previously ran even more variables because now I'm focusing on monthly data instead of daily like in my first attempt, but I never incurred into this problem. Can anyone help me here?
Here you can find my commands for the do-file:
"clear
set maxvar 15000
cd "C:\Users\ACER\Downloads\THESIS\EX"
import excel using ME.xlsm, sheet("ME") cellrange(B1:TNJ253) firstrow clear
gen time =_n
reshape long ME, i(time)
rename _j stock"
I previously ran even more variables because now I'm focusing on monthly data instead of daily like in my first attempt, but I never incurred into this problem. Can anyone help me here?
