Say that you use SPSS but wish to know how to do a particular command in Stata. For example, you want to make a new variable and know you can use the **compute** command to create a new variable in SPSS, but what is the equivalent (or similar) command in Stata? (By the way, there are actually three similar Stata commands, ** generate**, **replace** and **egen**). The table below shows you five columns of information.

- SPSS commands, listed in alphabetical order
- The equivalent (or similar) Stata command(s)
- Links to UCLA web pages that illustrate the use of the Stata command
- Cross references to the Stata manual for learning more about the command (which is also hot linked to the online help for the command)
- Cross references to books that illustrate more about the command.

This table is by no means complete, and it not intended to be a complete and exhaustive reference. Instead, it is intended to be a short, simple, sweet and handy reference for SPSS users who are making the transition to Stata. We also highly recommend A Sample Stata Session (via the Stata web site) which gives you a quick overview of using Stata as well as seeing the [GS] Getting Started manual that accompanied your purchase of Stata.

SPSS Command |
Stata Command(s) |
UCLA Web Pages |
Stata Manual |
Books |

ADD FILES | append | Combining data | [D] append | ishr – 9.5 |

AGGREGATE | collapse | Collapsing data across observations | [D] collapse | ishr – 9.6 |

ANOVA | anova | . | [R] anova | |

AUTORECODE | destring encode | How can I quickly convert many string variables to numeric | [D] destring [D] encode | |

CASESTOVARS | reshape wide | Reshaping data from long to wide | [D] reshape | |

COMMENT | * /* */ // | . | [P] comments | ishr 4.8 |

COMPUTE | generate replace egen | Creating and Recoding Variables | [D] generate [D] replace [D] egen | ishr 8.1 |

CORRELATIONS | correlate pwcorr | – Overview of statistical tests in Stata – Annotated output for the correlation command | [R] correlate | |

CROSSTABS | tabulate tab2 | Overview of statistical tests in Stata | [R] tabulate twoway | ishr 10.3 |

DATA LIST | infile infix insheet | Inputting raw data files into Stata | [D] infile (free format) [D] insheet [D] infix (fixed format) | ishr 6.3 |

DELETE VARIABLES | keep drop | Subsetting variables and observations | [D] drop | |

DESCRIPTIVES | summarize | – Descriptive information and statistics – Annotated output for the summarize command | [R] summarize | ishr 10.1 |

DISPLAY | describe | . | [D] describe | |

DOCUMENT | notes | . | [D] notes | |

DO IF | xyzcommand if |
Stata Learning Module: Using “if” for subsetting with Stata Commands | [U] 11.1.3 if exp | |

DO REPEAT | foreach | Working across variables using foreach | [P] foreach | ishr – 17.4 |

ECHO | display | . | [P] display | |

ERASE | erase | . | [D] erase | |

EXAMINE | tabulate x, summarize(y) | Overview of statistical tests in Stata | [R] tabulate, summarize() | |

EXECUTE | no equivalent | comment: transformation commands always immediately executed | none | |

EXPORT | no equivalent | comment: all Stata files can be used on all platforms | none | |

FACTOR | factor | Annotated output for the factor command | [MV] factor | |

FILE LABEL | label data | Labeling data, variables and values | [D] label | |

FILTER | xyzcommand if (___) |
Using “if” for subsetting with Stata Commands | [U] 11.1.3 if exp | |

FLIP | xpose | . | [D] xpose | |

FORMATS | format | . | [D] format | ishr – 5.2 |

FREQUENCIES | tabulate | Overview of statistical tests in Stata | [R] tabulate oneway | ishr – 10.3 |

GET FILE | use | Using and saving Stata data files | [D] use | ishr – 6.1 |

GET SAS | fdause | – SAS to Stata – SAS w/formats to Stata | [D] fdause | |

GRAPH | graph | Introduction to graphics | [G] graph | |

IF | generate __ if __ | Using “if” for subsetting with Stata Commands | [U] 11.1.3 if exp | ishr – 8.1 |

IGRAPH | graph | Introduction to graphics | [G] graph | |

INCLUDE FILE | do ___ | . | [R] do | |

LIST | list | . | [D] list | |

LOGISTIC REGRESSION | logistic | Data Analysis Example: Logistic Regression | [R] logistic | |

LOOP | forvalues | [P] forvalues | ||

MATCH FILES | merge | Combining Stata data files | [D] merge | ishr – 9.5 |

MEANS | tabulate __, summarize(__) | Overview of statistical tests in Stata | [R] tabulate, summarize() | ishr – 10.4 |

MISSING VALUES | none | . | [U] 12.2.1 Missing Values | |

MIXED | xtmixed | . | [XT] xtmixed | |

NOMREG | mlogit | Data Analysis Example: Multinomial Logistic Regression | [R] mlogit | |

PLUM | ologit | Data Analysis Example: Ordinal Logistic Regression | [R] ologit | |

PROBIT | probit | Data Analysis Example: Probit Regression | [R] probit | |

RECODE | recode | Creating and Recoding Variables | [D] recode | ishr – 8.4 |

RECORD TYPE | no equivalent | http://www.stata.com/support/faqs/data/hier.html | ||

REGRESSION | regress | – Regression with Stata – Annotated output for the regress command | [R] regress | |

RELIABILITY | alpha | . | [R] alpha | |

RENAME VARIABLES | rename | . | [D] rename | |

SAMPLE | sample | . | [D] sample | ishr – 9.2 |

SAVE | save | Using and saving Stata data files | [D] save | ishr – 6.1 |

SELECT IF | keep if drop if | Subsetting variables and observations | [D] drop | ishr – 9.2 |

SORT CASES | sort | . | [D] sort | ishr – 9.4 |

SPLIT FILE | by | . | [D] by [U] 11 Language syntax | ishr – 4.7 |

SUMMARIZE | tabulate ___, summarize(___) | Overview of statistical tests in Stata | [R] tabulate, summarize() | |

TEMPORARY. SELECT IF (___). | xyzcommand if (___) |
Using “if” for subsetting with Stata Commands | [U] 11.1.3 if exp | ishr – 4.4 |

T-TEST | ttest | Overview of statistical tests in Stata | ishr – 10.4 | |

VALUE LABELS | label values | Labeling data, variables and values |
[D] label |
ishr – 7.1 |

VARIABLE LABELS | label variable | Labeling data, variables and values | [D] label | ishr – 7.1 |

VARSTOCASES | reshape long | Reshaping data from wide to long | [D] reshape | |

WEIGHT | aw pw fw iw | What types of weights do SAS, Stata and SPSS support? | [U] l11.1.6 weight | ishr – 4.5 |

Legend

*xyzcommand*stands for any arbitrary Stata command- UCLA Web Pages
- “.” – no specific page exists. Try visiting the site and using the “search” command to pages that might tangentially refer to the command.
- Note that the hyperlinks have been removed. Please try to search for the title from the search bar.

- Stata Manual Names
- [D] Data
- [R] Reference manual
- [U] Users Guide
- [MV] Multivariate Statistics
- [XT] Cross sectional time series

- Book References
- ishr – Introduction to Stata for Health Researchers by Svend Juul