Hi all,
I'm an economics student in college, doing my best to learn STATA. I've browsed the forum and googled everything I could, it took me too long to realize I should just ask. I'm not extremely well versed in STATA, but I know my way around. I feel what I'm trying to do is pretty basic, so hopefully any help I receive will seem familiar to me.
In short I'm working towards doing an interrupted time series with a speed limit increase and crash data. My main objective right now is counting the number of crashes that occurred in each month so I can graph it. I have the date in different variables (as a date(crash_datetime "MDYhm") and as separate varables as month, year, etc.).
Since there are mutiple crashes on any given day, I need to count the observation on a given month/year, but I have not been able to figure it out. My knowledge (and apparently researching ability) of egen, count, and dates is inadequate.
Any help or nudge in the right direction is much appreciated,
Caleb
Related Posts with Counting observations over duplicate dates
Reshape help for household dataStata novice here so please be gentle, but I have a dataset from a household survey. Basic demograph…
calculating Growth rates with a gap of 3 years in a panel dataDear statlist, I am working on a panel data set and need to calculate growth rates of each panel ID…
Graphical analysis of ratesHello, I am new to STATA and am using Version 15. Due to the confidential nature of my data I canno…
Out-of-sample forecastingHello, I'm trying to forecast an arima(1,0,1) model with 4 variables out of sample. The dataset run…
Comparing rates in stataHello, I am new to STATA and am using Version 15. Due to the confidential nature of my data I canno…
Subscribe to:
Post Comments (Atom)
0 Response to Counting observations over duplicate dates
Post a Comment