Say that you use SAS 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 assignment statement (e.g. x = 1;) to create a new variable in SAS, 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
- SAS 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 SAS 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.
The first table shows SAS PROCs and the closest equivalent Stata command. The subsequent table shows statements from DATA Steps.
SAS PROCs to Stata commands
| SAS PROC | Stata Command(s) | UCLA Web Pages | Stata Manual | Books |
| PROC XYZ ; WHERE ___; | xyzcommand if (___) | Using “if” for subsetting with Stata Commands | [U] 11.1.3 if exp | ishr – 4.4 |
| PROC XYZ; BY abc; | by abc: xyzcommand | . | [D] by [U] 11 Language syntax | ishr – 4.7 |
| PROC XYZ ; WEIGHT wt; | xyzcommand [fweight=wt] | What types of weights do SAS, Stata and SAS support? | [U] l11.1.6 weight | ishr – 4.5 |
| PROC APPEND; | append | Combining data | [D] append | ishr – 9.5 |
| PROC COMPARE; | cf | . | [R] anova | |
| PROC CONTENTS; | describe | . | [D] describe | |
| PROC CORR | correlate pwcorr | – Overview of statistical tests in Stata – Annotated output for the correlation command | [R] correlate | |
| PROC CORR ALPHA; | alpha | . | [R] alpha | |
| PROC DELETE | erase | . | [D] erase | |
| PROC FACTOR | factor | Annotated output for the factor command | [MV] factor | |
| PROC FORMAT; FORMAT var fmt; | label define label values | Labeling data, variables and values |
[D] label |
ishr – 7.1 |
| PROC FREQ; TABLES a; | tabulate | Overview of statistical tests in Stata | [R] tabulate oneway | ishr – 10.3 |
| PROC FREQ; TABLES a*b; | tabulate tab2 | Overview of statistical tests in Stata | [R] tabuluate twoway | ishr 10.3 |
| PROC GLM; | anova | . | [R] anova | |
| PROC LOGISTIC; (binary); | logistic | Data Analysis Example: Logistic Regression | [R] logistic | |
| PROC LOGISTIC; (multinomial); | mlogit | Data Analysis Example: Multinomial Logistic Regression | [R] mlogit | |
| PROC LOGISTIC; (ordinal); | ologit | Data Analysis Example: Ordinal Logistic Regression | [R] ologit | |
| PROC MEANS; | summarize | – Descriptive information and statistics – Annotated output for the summarize command | [R] summarize | ishr 10.1 |
| PROC MEANS; CLASS a; VAR b; | tabulate a, summarize(b) | Overview of statistical tests in Stata | [R] summarize [R] tabulate, summarize() | ishr – 10.4 |
| PROC MIXED; | xtmixed | . | [XT] xtmixed | |
| PROC MEANS; OUTPUT; PROC SUMMARY; OUTPUT | collapse | Collapsing data across observations | [D] collapse | ishr – 9.6 |
| PROC PRINT; | list | . | [D] list | |
| PROC PRINTTO; | log | . | [R] log | |
| PROC PROBIT; | probit | Data Analysis Example: Probit Regression | [R] probit | |
| PROC REG; | regress | – Regression with Stata – Annotated output for the regress command | [R] regress | |
| PROC REG ; OUTPUT OUT= | predict | [R] predict | ||
| PROC ROBUSTREG; | rreg | Chapter 4 – Beyond OLS | [R] rreg | |
| PROC SORT; | sort | . | [D] sort | ishr – 9.4 |
| PROC STDIZE; | egen | Creating and Recoding Variables | [D] egen | ishr 8.1 |
| PROC TTEST | ttest | Overview of statistical tests in Stata | ishr – 10.4 | |
| PROC UNIVARIATE | summarize , detail | [R] summarize | ||
SAS DATA STEP Statements and the closest equivalent Stata command
| SAS DATA STEP Statement | Stata Command(s) | UCLA Web Pages | Stata Manual | Books |
| * ; /* */ (comments) | * /* */ // | . | [P] comments | ishr 4.8 |
| x = 2; (assignment) | generate replace egen | Creating and Recoding Variables | [D] generate [D] replace [D] egen | ishr 8.1 |
| ARRAY | foreach | Working across variables using foreach | [P] foreach | ishr – 17.4 |
| DATA in.new; | save | Using and saving Stata data files | [D] save | ishr – 6.1 |
| DO i = 1 to 10; | forvalues | . | [P] forvalues | |
| IF (cond) THEN x = ___; | generate x = __ if (cond) | Using “if” for subsetting with Stata Commands | [U] 11.1.3 if exp | ishr – 8.1 |
| INFILE INPUT | infile infix insheet | Inputting raw data files into Stata | [D] infile (free format) [D] insheet [D] infix (fixed format) | ishr 6.3 |
| IF (___) THEN OUTPUT; IF (___) THEN DELETE; | keep if ___ drop if ___ | Subsetting variables and observations | [D] drop | ishr – 9.2 |
| %INCLUDE | do ___ | . | [R] do | |
| FORMAT | format | . | [D] format | ishr – 5.2 |
| KEEP DROP | keep drop | Subsetting variables and observations | [D] drop | |
| LABEL | label variable | Labeling data, variables and values | [D] label | ishr – 7.1 |
| MERGE | merge | Combining Stata data files | [D] merge | ishr – 9.5 |
| PUT | display | . | [P] display | |
| SET data1; | use | Using and saving Stata data files | [D] use | ishr – 6.1 |
| SET data1 data2 data3; concatenating data files | append | Combining data | [D] append | ishr – 9.5 |
| RENAME | rename | . | [D] rename |
Legend
- PROC XYZ stands for any arbitary SAS procedure.
- 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