Stata keeps numbering of variables from previous reshape in memory

[Panagiotis Vorgias]

Hi all,

Not sure how to phrase this: I do a long-to-wide reshape which results in 34 new variables. The issue is that instead of Stata giving it names like var1-var34 it keeps counting from previous reshape attempt giving names var35-var69.
The embarrassing thing is that I have solved this once in past and even solved it once today somehow but don't know how...

Does anyone know how to fix this?

Thank you all

[Leonardo Guizzetti]

Rename your variables then do the reshape.

[Panagiotis Vorgias]

Thanks Leonardo, that worked.