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.
Identify 100 biggest companies within a firmyearDear all, We are trying to generate a new dummy variable (biggest_comp_d) indicating whether a comp…
percentage of missing data for each group?Dear All, Suppose that the data set is Code: webuse grunfeld, clear set seed 1234 replace…
Problem with a synth command : error "uno() invalid -- invalid numlist has too many elements"Dear all, As described in the title, I try to implement the Synthetic Control method on STATA to st…
Create local macro already with double quotataion marksDear Statalist I would like to create a local macro for an if-condition that already includes doubl…
Add Trend/Regression line in tslineHello! I have three parameters that measure an examiners performance over time. The data is noted f…
Subscribe to:
Post Comments (Atom)
0 Response to Formatting Data in STATA.
Post a Comment