Generate quarter from datetime

[Rochelle Zhang]

Dear Statalisters,

I have a variable called it fdate, it is stored as int type and format %d, e.g. 31dec2009, I know how to generate year by
gen year=year (fdate)

how do I generate quarter ? do i need to do qofd, then convert it back to quarter?

Many thanks,

Rochelle

[Rich Goldstein]

your question makes no sense; please show us what you have and what you want in a brief example (qofd does give you quarter (at least in a sense)

[Rochelle Zhang]

maybe I asked a silly question,

for example, fdate =31dec2009,the corresponding quarter would be 4, I suppose I could use month function to figure out which quarter it is then.

thanks,
Rochelle

[Rochelle Zhang]

my solution:
gen mon=month(fpedats)

gen qtr=1 if inlist(mon, 1, 2, 3)

replace qtr=2 if inlist(mon, 4, 5, 6)

replace qtr=3 if inlist(mon, 7, 8,9)

replace qtr=4 if inlist(mon, 10, 11, 12)

[Roberto Ferrer]

-help quarter-