Extract year from Date

[Jana Schue]

Hallo,

I have have a little problem and would be thankful if anyone could help me.
My dataset contains date in form of e.g. (19800229) and i want to extract the year (for this example 1980).

I already tried the command
gen fyear=year( fiscal_year_end)
but I just get missing values.

I think its because Stata can´t ready the format.

It would be great if anyone can help me.
Thanks in advance.

Best regards
Jana

[Øyvind Snilsberg]

If fiscal_year_end numeric and always 8 digits,

gen fyear = int(fiscal_year_end/10000)

If fiscal_year_end numeric but not always 8 digits,

tostring(fiscal_year_end),replace
gen fyear = real(substr(fiscal_year_end,1,4))

If fiscal_year_end string,

gen fyear = real(substr(fiscal_year_end,1,4))

[Nick Cox]

See also https://www.statalist.org/forums/for...dates-to-years

[Jana Schue]

It worked.

Thanks for your help!