Index

• General training page
• R training page
• What to do first?
• R’s screen
• Create a log file
• Set a working directory
• Allocate memory
• Open a R file
• How to put data into R
• From Excel (copy-and-paste)
• From *.csv (comma-separated)
• From *.txt (tab-separated)
• From SPSS
• From SAS
• From Stata
• From R
• From ASCII
• Data manipulation
• Reshape
1. Wide to long
2. Long to wide
• Merge / Append
• Rename
• Value to missing
• Date variables
1. d-m-yy
2. m/d/yyyy
3. yyyymd
4. Deconstructing
5. String with day of the week
• Time variables
• Moving average for panel data
• Sort variables (alphabetical)
• Selecting variables
• Descriptive statistics per group
• Replacing values
1. Changing units
2. Conditional
• Creating variables
1. From other variables
2. Conditional
• Browsing selected variables
• Collapse
• Miscellaneous
• Dealing with string variables
• Text to numbers
• Extracting from numeric or string combination (regexr)
• Deconstructing a numeric variable (substr)
• Dropping observations using a string variable(regexm)
• Publishing regression output
• Outreg2 (with F-tests)
• Outreg2 with Ivreg
• Selecting variables
• Start exploring your data
• Exploring the data
• Descriptive statistics
• Getting a codebook
• Counting panels
• Basic commands
1. Frequencies (tab)
2. Crosstabs (tab)
3. Multiple frequencies (tab1)
4. Descriptive statistics (tabstat)
5. Tab/summ
6. Proper
• One-way ANOVA
• Rolling standard deviation
• t-test
• Graphs
• Factor Analysis
• Interpretation (regression with logarithms)
• Descriptive Statistics (Excel/Stata/R)
• Linear regression (Stata)
• Linear regression (R)
• Panel data (fixed/random effects) (Stata)
• Panel data (fixed/random effects) (R)
• Multilevel analysis
• Data preparation & Descriptive Statistics
• Finding data (w/comments on crafting research questions)
• Times Series
• Logit regression & Ordered logit regression
• Factor analysis
• Notes on Exploring Data using R and Stata
• Programming in STATA (do-files)
• Do-file definition
• Do-file Hello1.do
• Reading data: Read1.do (using infile, ascii data)
• Reading data: Read2.do (using insheet, excel data)
• Reading data: Read2.do (keeping vars)
• Reading multiple files: Read3.do (using macros)
• Converting F to C: Convert.do (example using macros)
• Looping
• Generate and summarize (z-values example)
• Encode command
• While command
• Foreach command (looping, zvalue.do, macros)
• Forvalues command (looping, line.do, macros, graph)
• Exercise
• References
• STATA on PU Networks
• Thank you to Ashley Miller for this pdf document. Please contact her for any questions on this at ashleym@princeton.edu.