Hello everyone!
I have a dataset with monthly data. My date variable is in the format of "YM", so, e.g. "1983m1" (type = float, format =%tm)
Now, for each monthly observation, I want to create a month-of-the-year dummy for my regression.
I already tried the following code from another fellow member of the forum:
egen month =seq(), to (12)
tab month, gen(m)
Technically, this works perfectly fine. However, the problem is that sometimes, I have a month missing in my observation so that at one point, the month-of-the year dummies and my date variable are not running in sync anymore.
Is there a way that I can create my dummies directly based on my date variable? So that e.g. if my date variable jumps from "1983m1" directly to "1983m3", my month-of-the year dummy would also jump from "1" to "3" ?
Already thanks a lot for your time and support!
Related Posts with Creating month-of-the-year dummies
Joining frequency and percentage in same columnAny idea on how one can join the frequency and percentage into one column and order the row labels i…
Renaming graph labelsFor the bar graphs that are created using the data below, I am having trouble renaming the macro var…
Changing Odd Date Strings to Manageable DatesI have some data from Google trends that I'd like to maybe work with, following this interesting sto…
Help to interpret psmatch2 messages and resultsHi, I want to run a regression to compáre yield at issuance of green and non-green bonds. In order t…
Changing a string variable with various characters into a numerical (categorical) variableHi! I am fairly new to Stata and looking to organize one of my variables within a dataset. it is a l…
Subscribe to:
Post Comments (Atom)
0 Response to Creating month-of-the-year dummies
Post a Comment