![converting excel to stata in stat transfer converting excel to stata in stat transfer](https://pbs.twimg.com/profile_images/805446615444000769/jiL_X2um_400x400.jpg)
![converting excel to stata in stat transfer converting excel to stata in stat transfer](https://s3.amazonaws.com/libapps/accounts/11445/images/Libguide-Citrix-formats.png)
- Converting excel to stata in stat transfer software#
- Converting excel to stata in stat transfer windows#
If you have not yet installed it, typeĪnd follow the directions given. With Stata 12 or some earlier version, the easier way is to use the user-written routine usespss. Note that with later versions (currently, this is version IBM SPSS 22) things seem to work well. However, with IBM-SPSS version 19 problems may occur with the file simply not being written. If you have access to SPSS, you may save your file in Stata format and then use this version in Stata.
Converting excel to stata in stat transfer software#
One of these is using software designed specifically to convert files from one format to another, such as Stat/Transfer or DBMS copy. However, there are a number of workarounds. Use var1 var17 if id <= 1000 using name-of-data-file Data from other statistics softwareīy default, Stata is not prepared to read data from other statistical packages. Will load only cases with a value less than or equal to 1000 in variable id.īoth types of command may be combined, such as in Use if id <= 1000 using name-of-data-file Will load only the three variables mentioned into your working memory. Use var1 var17 var38 using name-of-data-file "Limiting" the data may refer to the variables used and/or to the selection of a subsample of cases. If you know from the outset that you need only parts of a data set, you may request Stata to limit the data to be loaded. Single quotation marks won't do the trick. Important note: If one or several of the directories or the name of the data set contain empty spaces (blanks), they have to be placed within double quotation marks. Another way is to change to the pertinent directory first and then to "use" the data file: Where you have to fill in your directory and data set name. Use c:\mydirectory\mysubdirectory\name-of-data-file If the data set can be found somewhere else, you may write, for instance
Converting excel to stata in stat transfer windows#
Up to now, I have assumed that the data are in your working directory, which normally is called "data" on a Windows PC. If you are already using another data set and want to replace it (either having saved it or not wanting to save it) with the new data set, you will write: If you want to use an already existing Stata system file (with extension ".dta"), the appropriate command is WLM-Stata - Read Data Internet Guide to Stata