Dear Statalist,
I am currently working with trade data and ideally want to reshape my data from the current setting (see graph in attachment) to the following format:
Year Tradeflow_import_AZ Tradeflow_export__AZ Tradeflow_import_C1 Tradeflow_export_C2
2017 123 456 789 101112
In the next step, I want to add the trade flows for the years 2012 and 2015 so it will be more convenient to have the data in the described format. I tried to use the reshape command but had some problems with defining i and j. Does anybody has an idea how I could approach the problem?
Thank you very much in advance!
Best,
Lea
I am currently working with trade data and ideally want to reshape my data from the current setting (see graph in attachment) to the following format:
Year Tradeflow_import_AZ Tradeflow_export__AZ Tradeflow_import_C1 Tradeflow_export_C2
2017 123 456 789 101112
In the next step, I want to add the trade flows for the years 2012 and 2015 so it will be more convenient to have the data in the described format. I tried to use the reshape command but had some problems with defining i and j. Does anybody has an idea how I could approach the problem?
Thank you very much in advance!
Best,
Lea
Comment