Stata FAQ
How do I do this SPSS command in Stata?
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 
TTEST 
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.
 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
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.