You can then write a separate do file that loads the Stata data set and carries out your analysis.Integrating a contemporary approach to econometrics with the powerful computational tools offered by Stata, An Introduction to Modern Econometrics Using Stata focuses on the role of method-of-moments estimators, hypothesis testing, and specification analysis and provides practical examples that show how the theories are applied to real data sets using Stata. That's why these do files simply import a data set and save it as a Stata data set. Importing an Excel spreadsheet or CSV file takes longer than loading a Stata data set, and there's no need to repeat that process every time you analyze the data. If it gets it wrong, you can specify that the first row contains variable names with the varnames(1) option. The import delimited command will try to figure out whether the first row contains variable names or data, and usually succeeds. Text files that put a specific character between variables are also known as delimited files, and the Stata command to read them is import delimited. Hence the name, comma-separated variable file. Importing CSV FilesĪ CSV file is really just a text file, but structured so that each line of text represents one observation and each variable is separated by a comma. If you have a complicated spreadsheet you might click File, Import Excel, tweak the options in the dialog box you get until it can read the spreadsheet successfully, then copy the resulting command into your do file. There are other options that let you specify which which worksheet to read, or to only read in part of a spreadsheet so you can skip titles or notes that aren't really data. Otherwise it will name the variables A, B, C, etc. The firstrow option tells Stata that the first row of the spreadsheet contains the names of the variables. xlsx, but if you do it needs to be the right one. When you give the filename of the spreadsheet you do not need to include.
Normally you tell Stata what data set you want to use with the use command, but if the data set is an Excel spreadsheet, use import excel instead. You can get the full data set from the GSS web site. Note that these files are subsets of the full GSS results. If you want to carry out the examples for this section, click on the following links to download a GSS sample in Excel format and a GSS sample in CSV format, then move them to your U:\SFS folder as described in Managing Stata Files. In this section we'll talk about how to import two of the most common kinds of data files: Excel spreadsheets and CSV (comma-separated variable) files.
If you are new to Stata we strongly recommend reading all the articles in the Stata Basics section. This article is part of the Stata for Students series.
0 kommentar(er)
