First steps in Stata 1: Import data

We are going to look into the case we have our data in an Excel file (which you can download by clicking here).

We open Stata, File, Import, Excel Spreadsheet:

And the following window appear:

In this case (as most of the times), our first row stands for the name of the variable, so we choose “Import first row as variable names”.  And press Ok.

And our data will be loaded. On the right, you will see the list of variables.

The data that we have imported is the gross flows of Inward Foreign Direct Investment in Spain by ultimate country in thousand of euros. Data retrieved from: http://datainvex.comercio.es/

We save as the information you have imported. File, Save As.  Is recommendable to save it in a place you won’t move it in the near future. In order to save time, is quite important to be organized.

Now we can go to the next section: First steps in Stata: Set names and labels

You can download the created file by clicking here.