hello,
I am working with panel data and I would like to convert data from wide format to long format with the purpose to carry out the following regressions. I have different variables (all numerics but one named "banche" the Italian word for "banks")
The variables are the following (all from 2021 to 2010):
npl (meaning npl2021, npl2020....., npl2010);
netinterestmargin (meaning netinterestmargin2021....., netinterestmargin2010)
avgequityavgassets (same)
costtoincome (same)
roaa (same)
llp (same)
assets (same)

I tried to post here the data but the output was really bad. If you need the exact data, please tell me how and I would be pleased to help you.

Ps I apologize but I don't how to show you the variables without reporting all the numbers (the dataset has over 11,000 observations)
I would like to have long format using "banche" as "i" and the time as "j". Could you please help me?
I used this command but it does not work.
Code:
reshape long npl, netinterestmargin, avgequityavgassets, costtoincome2021, roaa, llp, assets, i(banche) j(year)
it says
Code:
invalid 'avgequityavgassets'
I tried even with the following command
Code:
. reshape long *, i(banche) j(j)
I tried several times but I cannot understand why. Please help me.
Thanks a lot to everybody