Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • reshape wide to long with big

    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

  • #2
    Get rid of all the commas, except the one before i(banche).

    Comment


    • #3
      Thanks a lot Clyde for the awesome help you are giving me.
      King regards

      Comment


      • #4
        What happens when you type in
        Code:
        dataex in 1/100

        Comment

        Working...
        X