Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str4 country str10 var str5 code float(_1970 _1971 _1972 _1973 _1974) double(_1975 _1976 _1977 _1978 _1979 _1980 _1981 _1982 _1983 _1984 _1985 _1986) "AT" "VA" "TOT" . . . . . . . . . . . . . . . . . "AT" "VA" "MARKT" . . . . . . . . . . . . . . . . . "AT" "VA" "A" . . . . . . . . . . . . . . . . . "AT" "VA" "B" . . . . . . . . . . . . . . . . . "AT" "VA" "C" . . . . . . . . . . . . . . . . . "AT" "VA" "10-12" . . . . . . . . . . . . . . . . . "AT" "VA" "13-15" . . . . . . . . . . . . . . . . . "AT" "VA" "16-18" . . . . . . . . . . . . . . . . . "AT" "VA" "19" . . . . . . . . . . . . . . . . . "AT" "VA" "20-21" . . . . . . . . . . . . . . . . . "AT" "VA" "22-23" . . . . . . . . . . . . . . . . . "AT" "VA" "24-25" . . . . . . . . . . . . . . . . . "AT" "VA" "26-27" . . . . . . . . . . . . . . . . . "AT" "VA" "28" . . . . . . . . . . . . . . . . . "AT" "VA" "29-30" . . . . . . . . . . . . . . . . . end
In the above, I have information by country-variable-sector. So, line 1 is read as Austria-Value Added-Total. Thereafter, each column represents a different year. I wish to convert this to long format, with year as a single column, as opposed to separate columns. Any help on this is much appreciated!
0 Response to Sytanx for Going from wide to long
Post a Comment