I am working with data and I would like to know how to rearrange some variables. I have found it difficult to make this myself. The data looks like this:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str5(row2 col1) float value int time str3 cou "61" "01T03" 137.7 2005 "DEU" "61" "01T03" 153.1 2006 "DEU" "61" "01T03" 172 2007 "DEU" "61" "01T03" 106.9 2008 "DEU" "61" "01T03" 101.2 2009 "DEU" "61" "01T03" 99.1 2010 "DEU" "61" "01T03" 113.2 2011 "DEU" "61" "01T03" 92.8 2012 "DEU" "61" "01T03" 89.5 2013 "DEU" "61" "01T03" 90 2014 "DEU" "61" "01T03" 93.7 2015 "DEU" "85" "07T08" .3 2005 "DEU" "85" "07T08" .4 2006 "DEU" "85" "07T08" .4 2007 "DEU" "85" "07T08" .7 2008 "DEU" "85" "07T08" .6 2009 "DEU" "85" "07T08" .9 2010 "DEU" "85" "07T08" 1 2011 "DEU" "85" "07T08" .9 2012 "DEU" "85" "07T08" .8 2013 "DEU" "85" "07T08" .8 2014 "DEU" "85" "07T08" 1.5 2015 "DEU" "62T63" "09" 1.5 2005 "DEU" "62T63" "09" 1.6 2006 "DEU" "62T63" "09" 2 2007 "DEU" "62T63" "09" 2.3 2008 "DEU" "62T63" "09" 1.7 2009 "DEU" "62T63" "09" 1.5 2010 "DEU" "62T63" "09" 1.6 2011 "DEU" "62T63" "09" 1.4 2012 "DEU" "62T63" "09" 1.4 2013 "DEU" "62T63" "09" 1.9 2014 "DEU" "62T63" "09" 1.2 2015 "DEU" "29" "13T15" 48.2 2005 "DEU" "29" "13T15" 53.8 2006 "DEU" "29" "13T15" 60.4 2007 "DEU" "29" "13T15" 69.1 2008 "DEU" "29" "13T15" 56.8 2009 "DEU" "29" "13T15" 63.3 2010 "DEU" "29" "13T15" 80.2 2011 "DEU" "29" "13T15" 73.6 2012 "DEU" "29" "13T15" 72.9 2013 "DEU" "29" "13T15" 69.3 2014 "DEU" "29" "13T15" 93.1 2015 "DEU" "45T47" "10T12" 24554.2 2005 "DEU" "45T47" "10T12" 24896.9 2006 "DEU" "45T47" "10T12" 27681 2007 "DEU" "45T47" "10T12" 30817.8 2008 "DEU" "45T47" "10T12" 28665.2 2009 "DEU" "45T47" "10T12" 28014.5 2010 "DEU" "45T47" "10T12" 29790.5 2011 "DEU" "45T47" "10T12" 27765.9 2012 "DEU" "45T47" "10T12" 29186.7 2013 "DEU" "45T47" "10T12" 30008.9 2014 "DEU" "45T47" "10T12" 25077 2015 "DEU" "31T33" "01T03" 301.2 2005 "DEU" "31T33" "01T03" 323.5 2006 "DEU" "31T33" "01T03" 443.2 2007 "DEU" "31T33" "01T03" 103.8 2008 "DEU" "31T33" "01T03" 107.4 2009 "DEU" "31T33" "01T03" 106.7 2010 "DEU" "31T33" "01T03" 118.8 2011 "DEU" "31T33" "01T03" 114.1 2012 "DEU" "31T33" "01T03" 106.5 2013 "DEU" "31T33" "01T03" 120.4 2014 "DEU" "31T33" "01T03" 456.6 2015 "DEU" "31T33" "17T18" 501.9 2005 "DEU" "31T33" "17T18" 543.6 2006 "DEU" "31T33" "17T18" 635.7 2007 "DEU" "31T33" "17T18" 442 2008 "DEU" "31T33" "17T18" 1281.4 2009 "DEU" "31T33" "17T18" 725.9 2010 "DEU" "31T33" "17T18" 838.7 2011 "DEU" "31T33" "17T18" 694.4 2012 "DEU" "31T33" "17T18" 730.2 2013 "DEU" "31T33" "17T18" 676.4 2014 "DEU" "31T33" "17T18" 468.5 2015 "DEU" "68" "13T15" 658.3 2005 "DEU" "68" "13T15" 719.4 2006 "DEU" "68" "13T15" 786.1 2007 "DEU" "68" "13T15" 904.3 2008 "DEU" "68" "13T15" 799.3 2009 "DEU" "68" "13T15" 687.8 2010 "DEU" "68" "13T15" 467.4 2011 "DEU" "68" "13T15" 455.9 2012 "DEU" "68" "13T15" 474.2 2013 "DEU" "68" "13T15" 391 2014 "DEU" "68" "13T15" 397.9 2015 "DEU" "19" "07T08" 30.3 2005 "DEU" "19" "07T08" 35.7 2006 "DEU" "19" "07T08" 38.1 2007 "DEU" "19" "07T08" 277.7 2008 "DEU" "19" "07T08" 154.1 2009 "DEU" "19" "07T08" 188.2 2010 "DEU" "19" "07T08" 261.6 2011 "DEU" "19" "07T08" 246.9 2012 "DEU" "19" "07T08" 238.4 2013 "DEU" "19" "07T08" 209.3 2014 "DEU" "19" "07T08" 98.4 2015 "DEU" "13T15" "17T18" 45.3 2005 "DEU" end
I need this data to be similar to the one below:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input byte(row col) int time byte value str3 cou 61 1 2005 . "DEU" 61 2 2005 . "DEU" 61 3 2005 . "DEU" 45 10 2010 . "DEU" 45 11 2010 . "DEU" 45 12 2010 . "DEU" 46 10 2010 . "DEU" 46 11 2010 . "DEU" 46 12 2010 . "DEU" 47 10 2010 . "DEU" 47 11 2010 . "DEU" 47 12 2010 . "DEU" end
Thank you in advance
JL
0 Response to rearranging observations
Post a Comment