Good Evening Statalist,
I have this dataset below (small snippet of a larger set).
The numerical values in the columns are values for, say, US-Latvia 2000-2016. I have to put together a dataset, which is rather easy to do. But these values come from a large dataset. I would like to put the US in one column, and the other countries in another column respectively. I also would like another column with the years 2000-2016. For example, it should look more or less like this
How would I begin to go about this process? I couldn't find too much about copying string variables. I recently started reading about loops. Would this be a case for "foreach?"
I have this dataset below (small snippet of a larger set).
Code:
input str13 A str17 B str13 C str17(D E F) "United States" "United States" "United States" "United States" "United States" "United States" "Latvia" "Lebanon" "Lesotho" "Liberia" "Libya" "Lithuania" "306930.679" "79745.083" "146463.621" "47212.263" "" "148638.653" "160166.035" "92366.66099999999" "224044.424" "44717.257" "" "181852.287" "209911.079" "65999.47" "342916.727" "47565.578" "" "319909.315" "402127.868" "96023.288" "419667.164" "62020.299" "" "377984.417" "393820.304" "78064.427" "492916.794" "89327.53200000001" "345890.234" "526050.688" "386179.552" "91382.83" "421162.558" "97128.84" "1657014.694" "684444.485" "316645.799" "92733.285" "428555.478" "144436.479" "2629364.881" "611151.251" "354748.64" "110106.382" "461830.937" "118431.626" "3540204.282" "495967.455" "242113.62" "102171.373" "393199.228" "147594.515" "4349963.119" "795659.618" "151863.228" "79335.322" "315889.223" "84722.024" "1981281.659" "619556.909" "205856.497" "87770.742" "311795.845" "184387.544" "2186739.543" "665087.0699999999" "374815.397" "82917.895" "394700.104" "161518.682" "666411.2120000001" "1093273.328" "246245.171" "81186.78999999999" "310571.285" "143977.124" "2493042.856" "1176197.244" "272668.88" "91677.058" "351402.897" "96490.694" "2558215.497" "1554352.566" "286506.172" "75856.026" "372885.118" "87367.33500000001" "231534.712" "1137632.301" "317724.024" "96389.17200000001" "344158.896" "47175.347" "167148.641" "1114446.726" "350260.698" "110837.231" "319856.592" "67780.60400000001" "245277.491" "1241041.518" end
Code:
input str4 A str13 B str11 C double D "2000" "United States" "Afghanistan" 901.169 "2001" "United States" "Afghanistan" 791.872 "2002" "United States" "Afghanistan" 4746.212 "2003" "United States" "Afghanistan" 62735.495 "2004" "United States" "Afghanistan" 25091.199 "2005" "United States" "Afghanistan" 67649.574 "2006" "United States" "Afghanistan" 45827.15 "2007" "United States" "Afghanistan" 76810.325 "2008" "United States" "Afghanistan" 86906.964 "2009" "United States" "Afghanistan" 124107.6 "2010" "United States" "Afghanistan" 87474.254 "2011" "United States" "Afghanistan" 26636.658 "2012" "United States" "Afghanistan" 36759.941 "2013" "United States" "Afghanistan" 45514.058 "2014" "United States" "Afghanistan" 72809.599 "2015" "United States" "Afghanistan" 24493.917 "2016" "United States" "Afghanistan" 34458.766 end
Comment