Hi everyone !
As a student in my first year of my Master's degree, I have to make a dissertation about International Trade and Africa. This dissertation includes of course an econometric study. Since I have a gravity equation to do, I've download the Gravity database, which is a stata file, from the CEPII's website.
At first, I was thinking about copy/paste the data's from Stata to Excel, then build a new database with the datas I needed, then put the datas back on Stata ( which is easier for me since I use Excel quite a lot ). The problem is that, the database is huge ( more than 3 millions lines ) and I can't copy/paste the whole database. But my teacher told me that it might be possible to do it directly on Stata, but she don't know how to do, and me neither ( since it's my first year learning econometrics and the whole stuff ). She told me to ask on this forum to have answers.
So that's why I'm asking you if there's any command on Stata that can help me achieving what I want. If you want more precisions, the Gravity database consists of several variables associated to one country ( there's an ISO-code to name the countries ) which have impacts on its trades with another country ( and this is done for every country and every trade's relation with another country, that's why there's more than 3 millions lines ), and I need to select data's from only few countries.
Thanks for the help !
As a student in my first year of my Master's degree, I have to make a dissertation about International Trade and Africa. This dissertation includes of course an econometric study. Since I have a gravity equation to do, I've download the Gravity database, which is a stata file, from the CEPII's website.
At first, I was thinking about copy/paste the data's from Stata to Excel, then build a new database with the datas I needed, then put the datas back on Stata ( which is easier for me since I use Excel quite a lot ). The problem is that, the database is huge ( more than 3 millions lines ) and I can't copy/paste the whole database. But my teacher told me that it might be possible to do it directly on Stata, but she don't know how to do, and me neither ( since it's my first year learning econometrics and the whole stuff ). She told me to ask on this forum to have answers.
So that's why I'm asking you if there's any command on Stata that can help me achieving what I want. If you want more precisions, the Gravity database consists of several variables associated to one country ( there's an ISO-code to name the countries ) which have impacts on its trades with another country ( and this is done for every country and every trade's relation with another country, that's why there's more than 3 millions lines ), and I need to select data's from only few countries.
Thanks for the help !
Comment