Good Afternoon,
I am an Economics student and I am using STATA for a group project where we are analyzing firearms background checks as a proxy for gun sales, the state crime rates regarding violent crimes for Colorado, Texas and New Jersey, we are also analyzing income.
We have our equations as follows:
Gun Sales = ^pie,0 + ^pie1, sunshine, which is our two stage least squares.
Crime Rate = Bo+(B1) Gun Sales + (B2) Income + (B3) Race + (B4) Age + (B5) Gender + μ, which is our instrumental variable regression.
We have three data sets that downloaded into excel, transposed and then turned into CSV.
We are trying to determine if our data needs to be reshaped in STATA and what variables need to be generated and what commands need to be used.
Thus far we have:
clear
set more off
insheet using FBC.csv
clear
set more off
insheet using SCR.csv
clear
set more off
insheet using income.csv
https://drive.google.com/drive/folde...4J?usp=sharing
This is a link to the CSV files.
We are trying to determine if the data needs reshaped and what variables will need to be generated in order to run summaries, regressions and create line and/or scatter plots.
Related Posts with Formatting Data in STATA.
xtreg, fe robust: xtoverid error(2b) operator invalid when correcting Hausman test (V_b-V_B is not positive definite) due to year dummiesDear Statalisters, I am analyzing a panel dataset with year dummies over a period of 2000-2018 and …
one year survival - data managementgood day all I have a list of children with 2 variables "date of birth" and "date of death". Both a…
Medeff command: invalid mediate (error r(198))Dear Statalists, Could you please tell me the reason why when I type the following command: medeff…
Doubt on Heckprob model resultsHello everybody, I'm running a Heckman selection model based on a heckprob. I have some categorical…
Comparing two waves with RE-LogitI am currently using Panel data from the SOEP to analyze and compare political interest in 2013 and …
Subscribe to:
Post Comments (Atom)
0 Response to Formatting Data in STATA.
Post a Comment