[R] Year and month from a sequence

[Miluji Sb]

Dear all,
I have a panel dataset with a large number of groups (200K+) with a
sequence representing the month of the observations (2400 - 4139). The data
is from January 1861 to December 2005.
My goal is to extract the corresponding month and year for each observation.

I tried the following;
x$dt <- seq(from=as.Date("1861-01-01"),by='1 month',length=209000)

However, the end date is clearly out of the range. I would like to convert
the month number (2400 - 4139) to January 1861 to December 2005 by ID. How
can I achieve this? Any help will be highly appreciated.

Best,

Milu

	[[alternative HTML version deleted]]