tab year, gen(year_dummy)

[River Huang]

Dear All, In the following example

webuse grunfeld, clear

tab year, gen(year_dummy)

we can generate year_dummy1 for the year 1935, year_dumm2 for the year 1936, and so on. Is it possible to generate year_dummy1935 for the year 1935, year_dummy1936 for the year 1936, and so on? Thanks.

[Ali Atia]

If there are no missing years:

tab year, gen(year_dummy)
ren year_dummy# year_dummy#, renumber(1935)

If there are missing years (e.g., a jump from 1935 to 1937):

tab year, gen(year_dummy)
foreach year of varlist year_dummy*{
    gsort -`year'
    rename `year' year_dummy`=year[1]'
}

[River Huang]

Dear Ali, Thanks again for these suggestions.

[Nick Cox]

See also recent posts within https://www.statalist.org/forums/for...-dummy-by-year

[River Huang]

Dear Nick, I saw your reply in the post. Thanks.

[Romalpa Akzo]

Another way to go:

webuse grunfeld, clear

separate year, by(year) gen(Dum)
recode Dum* (.=0) (* = 1)

[River Huang]

Dear Romalpa, Thanks for this interesting suggestion.