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
Problem with merging data files into one fileHi everyone, i am preparing a panel dataset to run analysis for my research project. The data files …
Impact analysis Reforms in Power sector on Household energy affordabilityDear all, I am facing a problem in setting up a methodological framework to analyze 'impact of powe…
How to amalgamate multiple observations for a single patients into one observationHi, I am sure this problem has been discussed before, but I just cannot find the solution to my prob…
Semiparametric Difference-in-DifferencesHi Any suggestions on how to implement Semiparametric DID for repeated cross-section datasets? STA…
reshaping a dataset for a discrete choice model/conditional logit?Hey folks. I have data from a survey in which I ask each respondent to complete two discrete choice …
Subscribe to:
Post Comments (Atom)
0 Response to Creating month-of-the-year dummies
Post a Comment