8 Importing data
Copying and pasting
One of the easiest ways to get data into Stata is often overlooked: you can copy data from most
applications that understand the concept of a table and then paste the data into the Data Editor. This
approach works for all spreadsheet applications, many database applications, some word-processing
applications, and even some webpages. Just copy the full range of data, paste it into the Data Editor,
and everything will probably work well. You can even copy a text file that has the pieces of data
separated by commas and then paste it into the Data Editor.
Suppose that your friend has a small dataset about some very old cars.
VW Rabbit,4697,25,1930,3.78
Olds 98,8814,21,4060,2.41
Chev. Monza,3667,,2750,2.73
,4099,22,2930,3.58
Datsun 510,5079,24,2280,3.54
Buick Regal,5189,20,3280,2.93
Datsun 810,8129,,2750,3.55
You would like to put these data into Stata. Doing so is easier than you think:
1. Clear out your current dataset by typing clear.
2. Copy the data from the PDF documentation the way you would copy anything from any document.
(For best results, use Adobe Reader.)
3. Open the Data Editor in edit mode.
4. Select Edit > Paste Special....
5. Stata sees that the column delimiters are commas and shows how the data would look.
6. Click on the OK button.
You can see that Stata has imported the data nicely.
Later in this chapter, we would like to bring these data into Stata without copying and pasting,
so we would like to save them as a text file. Go back to the main Stata window, and click on the
Do-file Editor button, , to open a new Do-file Editor window. Paste the data in the Do-file
Editor, then click on the Save button. Navigate to your working directory, and save the file as a few
cars.csv. If you do not know what your working directory is, look in the status bar at the bottom
of the main Stata window.
Be careful if you are copying data from a spreadsheet because spreadsheets can contain special
formatting that ruins its rectangular form. Be sure that your spreadsheet does not contain blank rows,
blank columns, repeated headers, or merged cells because these can cause trouble. As long as your
spreadsheet looks like a table, you will be fine.
Commands for importing data
Copying and pasting is a great way to bring data into Stata, but if you need a clear audit trail for
your data, you will need another way to bring data into Stata. The rest of this chapter will explain
how to do this. You will also learn methods that lend themselves better to repetitive tasks and methods
for importing data from a wide variety of sources.
1