Data Processing

with Stata 15 Cheat Sheet

For more info see Stata's referenc.e manual (stata.com)

F2 -121� -" � Jttons

describe data

Ctrl + 8

Ctrl + 9

open a new .do file

Ctrl + D

open the data editor

clear

delete data in memory highlight text in .do file,

then ctrl + d executes it

in the command line

rll = � t4A�0 D P

PgUp PgDn serali through previous commands

Tab autocompletes vanable name after typing part

cls clear the console (where results are displayed)

pwdl

print current (working) directory

cd "C\Program Files (x86)\Stata13"

change working directory

dir

display filenames in working directory

dir".dta

List all Stata data in working directory

.cauture log close---------t

close the log on any existing do files

log using "myDoFile.txr, replace

create a new log file to record your work and results

search mdesc 1 _ ,,

find the package mdesc to mstall ra e :I'--nands that

ssc i nstall mdesc �- �o

install the package mdesc; needs to be done once

lmp9rt:pat

sysuse auto, clear } fo ma exarrpes re

load system data (Auto data) u,e ttie auto dataset

use ·yourStataFile.dta ·, clear

load a dataset from the current directory . ed

import excel ·yourSpreadsheetxlsx·, r-·.

•; sheet("Shee,1") cellrange(A2:H11) firstrow

import an Excel spreadsheet

import delimited "yourFile.csv·, /*

"/ rowrange(Z:11) colrange(1:8) varnames(Z)

import a .csv file

web use set ·olll)S://githl,1><lC>ff'/G�ntortstmrr.,,nog1raw/ma:ter/OayZJO•,.,·

webuse "wb_indicators_long·

set web-based directory and load data from the web

Basic Syntax

Ali Stata commands have the same fermat (syntax):

[by varlist1:] commond [varlist2] [ =exp] [if exp] [in range) [weight] [using filename] Loptions]

._________, �--� ._________.

�-do

--- -. '--

command

• e :nplE- Yt'E "'i1r.:: • on ed ,... __

vrrist1 bysort rep78. summarize price if foreign == O & price <= 9000, deta:I " wc _. � oh.. ,,..'":i a-d �a

To find out more about any command -like what options it takes -type help command

Arithmetic

add (numbers) &

+combine (strings) and

! or-not

or ! =] not

-Cli'= equa! < less than ual

'lhle

< = less than or equa! to

> greater than

-subtract

" multiply if fo<eign !� 1 & price : 10000 > = greater or equa I to

rf fore�n 1: 1 ( pnce : 10000

/ divide"

" raise to a power

Ex lare Data

_g_escribe make price

display variable type, fermat.

and any value/variable labels

count

count if price > 5000

number of rows (observations)

Can be combined wIth logie

ds, has(type string)

lookfor '1n.·

search far variable types.

vanable name. or variable label

isid mpg

check if mpg un1quely

identifies the data

codebook make price

overv1ew of vanable type, stats.

number of missing/unique values

summarize make price mpg

print summary statistics

(mean. stdev. min. max)

far variables

inspect mpg

show histogram of data.

number of missing or zero

observations

histogram mpg, freguency �

plot a histogram of the

distribution of a variable

IN_THl [

browse or Ctrl + 8

open the data editor nge

�-----,,u bo/ -€

!ist make pnce if price > 10000 & tmissing(pnce) gist .. 1co'T1pact formJ

list the make and price far observations with price > $10,000

.display price[4]

display the 4th observation in price; only works on single values

gsort price mpg (a:.cend r,g) gsort -price -mpg (de$Cendingl

sort in arder. first by price then miles per gallon

duplicates report assert price!=.

finds ali duplicate values in each variable verify trum of claim

levelsof rep78

display the uruque values far rep78

�� ·��r'.i%l•r:-� ._

Stata has 6 data types, and data can also be missing:

ru2..da!a tme/false WQ!ds .r:ll..l!Ilbill

m1ssmg byte string int long float double

To convert between numbers & strings:

gen foreign'String = string(foreigo)

tostring foreign, gen(foretgnStnng)

.d.ecode foreign. gen(forégnString) ·1·

·1·

"foreign'

gen or<? g-, ,L,..,e -= real(fore g�" "';, ì"

destrlng fo '? gnStr !'19. gen(fo '? gnNums" .. J ·1•

encode 'c"t ':i,: '::i gen(fc,,, gnNum,; ._) "foreign"

recast double mpg

generic way to convert between types

� " 7nacie fo, � rep7.:.

� [ uC -• • b -n:,p,;; �rrl

1.abul ate rep 78, mi 1ge n(repairRecord)1

one-way table: number of rows with each value of rep78

tabulate rep78 foreign, mi

two-way table: cross-tabulate number of observations

tor each combination of rep78 and foreign

_bys_ort rep78: tabulate foreign

far each value of rep78, apply the command tabulate foreign

tabstat price weight mpg, by(foreign) stat(mean sd n)

create compact table of summary statistics -sia:s

i = � ç,

��.--'---,

table foreign, contents(mean price sd price) f(%9 Zfc) row

create a flexible table of summary statistics

collapse (mean) price (max) mpg, by(foreign)-ep .::e'?. c.;;-�

calculate mean price & max mpg by car type (foreign)

generate mpgSo = mpg"Z gen byte lowPr = price < 4000

create a new variable. Useful also tor creating binary

variables based on a condition (generate byte)

generate id = _n bysort rep78: gen repairldx = _n

_n creates a running index of observations in a group

generate totRows = _N bysort rep78: gen repairTot = _N

_N aeates a running count of the total observations per group

pctile mpgQuartile = mpg, nq = 4

create quartiles of the mpg data

egen meanPrice = mean(price), by(foreign) -help egen

calculate mean price far each group in forergn � rrore opoo-,s

updated June 2016

�

Stata Commands Cheat Sheet, Cheat Sheet of Introduction to Econometrics

Related documents

Partial preview of the text

Download Stata Commands Cheat Sheet and more Cheat Sheet Introduction to Econometrics in PDF only on Docsity!

Data Processing

with Stata 15 Cheat Sheet

For more info see Stata's referenc.e manual (stata.com)

F2 - 121 � -" � Jttons

describe data

Ctrl + 8

Ctrl + 9

open a new .do file

Ctrl + D

open the data editor

clear

delete data in memory

highlight text in .do file,

then ctrl + d executes it

in the command line

PgUp PgDn serali through previous commands

Tab autocompletes vanable name after typing part

cls clear the console (where results are displayed)

pwdl

print current (working) directory

cd "C\Program Files (x86)\Stata13"

change working directory

dir

di splay filenames in working directory

dir".dta

List all Stata data in working directory

.cauture log close---------t

close the log on any existing do files

log using "myDoFile.txr, replace

create a new log file to record your work and results

find the package mdesc to mstall ra e :I'--nands that

ssc i nstall mdesc �-^ �o

install the package mdesc; needs to be done once

sysuse auto, clear

load system data (Auto data)}^ fou,e ttie auto dataset^ ma^ exarrpes re

use ·yourStataFile.dta·, clear

load a dataset from the current directory. ed

import an Excel spreadsheet

import delimited "yourFile.csv·, /*

"/ rowrange(Z:11) colrange(1 :8) varnames(Z)

import a .csv file

web use set ·olll)S://githl,1>ff'/G�ntortstmrr.,,nog1raw/ma:ter/OayZJO•,.,·

webuse "wb_indicators_long·

set web-based directory and load data from the web

Ali Stata commands have the same fermat (syntax):

[by varlist1:] commond [varlist2] [=exp] [if exp] [in range) [weight] [using filename] Loptions]

vrrist1 bysort rep78. s ummarize^ price^ if foreign == O & price <= 9000, deta:I^ "^ wc _.^ � oh.. ,,..

'":i a-d �a

add (numbers) &

+ combine (strings)

and

! or- not

or

-Cli'= equa!

< less than

ual