Dear stata community,
i am working on my bachelors thesis at the moment and i need to reshape my data sets before running my regression and im already having Problems .
I have Importer and Exporter of FDI in one column, but im trying to reshape it so they are separated and i have two variables one for inward and one for outward by country and year.
------------------ copy up to and including the previous line ------------------
Listed 100 out of 741609 observations
Use the count() option to list more
if you wanna know how the data looks in the data editor you can see it in the attachements.
Thanks for your help stata masters kind regards
Maximilian Kranz
i am working on my bachelors thesis at the moment and i need to reshape my data sets before running my regression and im already having Problems .
I have Importer and Exporter of FDI in one column, but im trying to reshape it so they are separated and i have two variables one for inward and one for outward by country and year.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str30 measurementprinciple str3 cou int year "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 "Directional principle: Inward" "AUS" 2015 "Directional principle: Inward" "AUS" 2016 "Directional principle: Inward" "AUS" 2017 "Directional principle: Inward" "AUS" 2018 "Directional principle: Inward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Outward" "AUS" 2013 "Directional principle: Outward" "AUS" 2014 "Directional principle: Outward" "AUS" 2015 "Directional principle: Outward" "AUS" 2016 "Directional principle: Outward" "AUS" 2017 "Directional principle: Outward" "AUS" 2018 "Directional principle: Outward" "AUS" 2019 "Directional principle: Inward" "AUS" 2013 "Directional principle: Inward" "AUS" 2014 end
Listed 100 out of 741609 observations
Use the count() option to list more
if you wanna know how the data looks in the data editor you can see it in the attachements.
Thanks for your help stata masters kind regards
Maximilian Kranz

Comment