Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Taking a dataset from panel dataset

    Hello, I have this panel dataset which I have made some new variables over the years. This new variables take one number each year as you can see for 2004 all take the value 0 but for year 2005 they each take different value but still the same throught out the year each year. I want to make a new dataset which each year will take only the one variable and not take the same multiple times. I want to have the same formation(year Variable1 Variable2 etc). This is just an example of my data but I want to take around 14 variables and the year variable as well. My variables format %9g, %10g and their type is float,double respectively. Thanks in advance.



    input float(year SOSCOR TRESG WVR_SV WVR_BV WVR_SL SMB HML HMLESG WVR EMR SICCode) double TotalGooTrends
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 3511 3729
    2004 . . 0 0 0 0 0 0 0 . 7389 3729
    2004 . . 0 0 0 0 0 0 0 . 2834 3729
    2004 . . 0 0 0 0 0 0 0 . 5531 3729
    2004 . . 0 0 0 0 0 0 0 . 6099 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 3492 3729
    2004 . . 0 0 0 0 0 0 0 . 6029 3729
    2004 . . 0 0 0 0 0 0 0 . 7389 3729
    2004 . . 0 0 0 0 0 0 0 . 3536 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 3841 3729
    2004 10.39 21.47 0 0 0 0 0 0 0 . 6331 3729
    2004 . . 0 0 0 0 0 0 0 . 4311 3729
    2004 . . 0 0 0 0 0 0 0 . 3541 3729
    2004 . . 0 0 0 0 0 0 0 . 2834 3729
    2004 . . 0 0 0 0 0 0 0 . 3845 3729
    2004 . . 0 0 0 0 0 0 0 . 4812 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 1311 3729
    2004 . . 0 0 0 0 0 0 0 . 2819 3729
    2004 . . 0 0 0 0 0 0 0 . 6021 3729
    2004 . . 0 0 0 0 0 0 0 . 3523 3729
    2004 . . 0 0 0 0 0 0 0 . 1531 3729
    2004 . . 0 0 0 0 0 0 0 . 4931 3729
    2004 . . 0 0 0 0 0 0 0 . 2869 3729
    2004 . . 0 0 0 0 0 0 0 . 4512 3729
    2004 . . 0 0 0 0 0 0 0 . 4911 3729
    2004 . . 0 0 0 0 0 0 0 . 8742 3729
    2004 . . 0 0 0 0 0 0 0 . 7371 3729
    2004 . . 0 0 0 0 0 0 0 . 8011 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 6726 3729
    2004 . . 0 0 0 0 0 0 0 . 5211 3729
    2004 22.29 25.49 0 0 0 0 0 0 0 . 7361 3729
    2004 . . 0 0 0 0 0 0 0 . 2836 3729
    2004 . . 0 0 0 0 0 0 0 . 3484 3729
    2004 . . 0 0 0 0 0 0 0 . 5999 3729
    2004 . . 0 0 0 0 0 0 0 . 7373 3729
    2004 . . 0 0 0 0 0 0 0 . 1311 3729
    2004 . . 0 0 0 0 0 0 0 . 3679 3729
    2004 . . 0 0 0 0 0 0 0 . 5193 3729
    2004 . . 0 0 0 0 0 0 0 . 1041 3729
    2004 . . 0 0 0 0 0 0 0 . 6029 3729
    2004 . . 0 0 0 0 0 0 0 . 3842 3729
    2004 . . 0 0 0 0 0 0 0 . 1531 3729
    2004 48.68 49.41 0 0 0 0 0 0 0 . 6021 3729
    2004 . . 0 0 0 0 0 0 0 . 3845 3729
    2004 . . 0 0 0 0 0 0 0 . 7375 3729
    2004 . . 0 0 0 0 0 0 0 . 4931 3729
    2004 . . 0 0 0 0 0 0 0 . 2834 3729
    2004 . . 0 0 0 0 0 0 0 . 3691 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 133 3729
    2004 . . 0 0 0 0 0 0 0 . 7371 3729
    2004 . . 0 0 0 0 0 0 0 . 2671 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 6035 3729
    2004 . . 0 0 0 0 0 0 0 . 7371 3729
    2004 8.1 9.96 0 0 0 0 0 0 0 . 3842 3729
    2004 . . 0 0 0 0 0 0 0 . 3562 3729
    2004 20.14 17.73 0 0 0 0 0 0 0 . 6162 3729
    2004 . . 0 0 0 0 0 0 0 . 6282 3729
    2004 . . 0 0 0 0 0 0 0 . 3241 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 6035 3729
    2004 . . 0 0 0 0 0 0 0 . 132 3729
    2004 . . 0 0 0 0 0 0 0 . 3711 3729
    2004 29.34 26.67 0 0 0 0 0 0 0 . 1021 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 2834 3729
    2004 . . 0 0 0 0 0 0 0 . 6798 3729
    2004 . . 0 0 0 0 0 0 0 . 7359 3729
    2004 . . 0 0 0 0 0 0 0 . 2992 3729
    2004 . . 0 0 0 0 0 0 0 . 5051 3729
    2004 29.76 33.79 0 0 0 0 0 0 0 . 2099 3729
    2004 . . 0 0 0 0 0 0 0 . 6022 3729
    2004 . . 0 0 0 0 0 0 0 . 2834 3729
    2004 . . 0 0 0 0 0 0 0 . 3812 3729
    2004 . . 0 0 0 0 0 0 0 . 6021 3729
    2004 27.56 27.44 0 0 0 0 0 0 0 . 3674 3729
    2004 . . 0 0 0 0 0 0 0 . 8731 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 13.46 14.65 0 0 0 0 0 0 0 . 4813 3729
    2004 . . 0 0 0 0 0 0 0 . 3149 3729
    2004 . . 0 0 0 0 0 0 0 . 4911 3729
    2004 63.26 61.97 0 0 0 0 0 0 0 . 4911 3729
    2004 . . 0 0 0 0 0 0 0 . 7374 3729
    2004 . . 0 0 0 0 0 0 0 . 7375 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 2761 3729
    2004 . . 0 0 0 0 0 0 0 . 6022 3729
    2004 . . 0 0 0 0 0 0 0 . 5511 3729
    2004 . . 0 0 0 0 0 0 0 . 7372 3729
    2004 . . 0 0 0 0 0 0 0 . 6099 3729
    2004 . . 0 0 0 0 0 0 0 . 6036 3729
    end

    clear
    input float(year SOSCOR TRESG WVR_SV WVR_BV WVR_SL SMB HML HMLESG WVR EMR SICCode) double TotalGooTrends
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6282 3646
    2005 34.8 46.13 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3253 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5999 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3724 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7389 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7372 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7372 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5140 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3841 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3571 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2869 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2033 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7379 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3691 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6029 3646
    2005 22.78 15.26 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4932 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2834 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4225 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7371 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6798 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6531 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6799 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6282 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4813 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2836 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3714 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6211 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2086 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3674 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7374 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3452 3646
    2005 13.97 44.3 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3432 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6794 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3541 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8731 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4512 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 1311 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3537 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8731 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2834 3646
    2005 6.77 21.05 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4212 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6798 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6512 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7372 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 . 7372 3646
    2005 31.58 30.46 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6798 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4911 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5171 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3841 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8742 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2711 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6512 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3949 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3312 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5812 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5099 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6035 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3089 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7372 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7375 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8731 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3648 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2834 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3355 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6282 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3841 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2821 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7361 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 . 4833 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7373 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7372 3646
    2005 16.86 13.67 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4931 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3842 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7371 3646
    2005 40.93 51.18 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4812 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6211 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3089 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8731 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8731 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7373 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 8011 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2911 3646
    2005 40.26 23.79 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6798 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6029 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2873 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3711 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 1389 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6512 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5812 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6035 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 5171 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 2512 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4522 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6099 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 1311 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 3433 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 4813 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 6321 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7323 3646
    2005 . . 19.791643 46.25453 -21.18624 98.07274 114.66677 50.66193 42.71373 -.024456305 7389 3646
    end

    Tags: None
Previous Next
Working...
X