Help the Stat Consulting Group by giving a gift

Stat/Transfer is a program that makes it very easy to convert files from one file format to another file format (for example, from a SAS data file to a Stata data file). You can get your own copy of Stat/Transfer at academic pricing. Please see the How to Get Stata page which includes information about how to get Stat/Transfer.

You can visit the
The Stat/Transfer web site for
more information, including

The Stat/Transfer FAQ page

Stat/Transfer for Unix Documentation

Download a demo of Stat/Transfer .

For more information, please visit FAQ: How do I convert among SAS, Stata and SPSS? .

Sometimes, you may want to or have to transfer only part of your data set from one format to another format instead of the entire one. For example, you have a data set of hospital patients and you only want to use the subset of female patients. Other occasions, you have to trim down your data set so to fit in a specific statistical package. For example, LimDep only allows 199 variables.

Subsetting observationsIn Stat/Transfer, there are a couple of categories to choose. One of them is called

Observations. You can click on that one, and Stat/Transfer will list all the operators you can use to subset your data set. Let's take a look at an example. We have a dataset calledhs2.savin SPSS format with 200 observations and we want to convert it into Stata format. There is a variable called FEMALE in the data set. Let's say that we want only the females in that data set, that is, we want observations with FEMALE=1. This can be done in Stat/Transfer easily. Once we have entered the correct path to our data set inTransferdialog box, we can then click on theObservationstag and enterFEMALE=1at the bottomwheredialog box as shown below.Notice that on the right hand side, we see all the variables in the data set. We then go back to the

Transferdialog box and proceed to transfer. At the bottom of the screen shot below, Stat/Transfer tells us that 109 observations were transferred.

Subsetting variablesSimilarly, you can choose variables that you want to convert using the

Variablesdialog box.Let's look at an example. We have a data set called

test.savin SPSS format. It has 401 variables and 1000 observations. We want to convert the data set into LimDep for Windows format. We first put the correct path to the data file inTransferdialog box. At this point, if we try to transfer, Stat/Transfer will pop up a dialog box giving us warnings that the limit on number of variables in LimDep for Windows is 199 and the data set has 401 variables. Let's say we really only need the first 150 variables, R1-R150. We want to select only those variables.We now click on the

Variablestag and following window is present.Notice that all the variables are selected by default. We need first to click the

UnSelect Allbutton to unselect the variables and then enter the variable names that we want to select and then click theKeepbutton shown below.

Returning back to

Transferdialog box, we can do the transfer now by clicking on theTransferbutton. Stat/Transfer tells us that 150 variables out of 401 have been selected and 1000 observations have been transferred.

The content of this web site should not be construed as an endorsement of any particular web site, book, or software product by the University of California.