Comma/tab separated file (no variable names in file)Ĭonsider a file that is identical to the one we examined in the previous section, but it does not have the variable names on line 1 type auto3.raw AMC Concord, 22, 2930, 4099 (However, insheet could not handle a file that uses a mixture of commas and tabs asīefore starting the next section, let’s clear out the existing data in memory. The insheet command is clever because it can figure out whether you have a comma delimited or tabĭelimited file, and then read it. The exact same insheet command could be used to read a tab delimited file. Now that the file has been read into Stata, you can save it with the save command (we will skip doing that step). Since you will likely have more observations, you can use in to list just a subset of observations. We can check to see if the data came in right using the list command. This kind of file can be read using the insheet command, as shown below. – The following lines have the values for the variables, also separated by commas. – The first line has the names of the variables separated by commas, Consider the comma delimited file shown below. Such files are commonly made from spreadsheet programs like Excel. Two common file formats for raw data are comma separated files and tab separated files. Comma/tab separated file with variable names on line 1 To learn more about the Stata data editor, see the edit module. It is useful when your data is on paper and needs to be typed in, or if your data is already typed into an Excel spreadsheet.

One of the easiest methods for getting data into Stata is using the Stata data editor, which resembles an Excel spreadsheet. You can create them yourself to try out thisĬode by copying and pasting the data into a text file. Note: all of the sample input files for this page were created by us and are This covers inputting data with comma delimited, tab delimited, space delimited, and fixed column data. This module will show how to input your data into Stata.

Stat transfer use first row as names