Hello,

I am wondering how to generate monthly time series data. For example, my current data set is constructed as follow

ccode1 ccode2 year
750 770 1947
750 770 1948
750 770 1949
750 770 1950
750 770 1951
750 770 1952
750 770 1953
750 770 1954
750 770 1955
750 770 1956
. . .
. . .
. . .
. . .
750 770 2003
750 770 2004
750 770 2005
750 770 2006
750 770 2007
750 770 2008
750 770 2009
750 770 2010
750 770 2011

From this data set, what I want to generate is as follow

ccode1 ccode2 year month date
750 770 1947 1 01jan1947
750 770 1947 2 01feb1947
750 770 1947 3 01mar1947
750 770 1947 4 01april1947
. . . . .
. . . . .
750 770 1947 11 01nov1947
750 770 1947 12 01dec1947
750 770 1948 1 01jan1948
750 770 1948 2 01feb1948
750 770 1948 3 01mar1948
750 770 1948 4 01april1948
. . . . .
. . . . .
750 770 1948 11 01nov1948
750 770 1948 12 01dec1948
. . . . .
. . . . .
750 770 2011 1 01jan2011
750 770 2011 2 01feb2011
. . . . .
. . . . .
750 770 2011 11 01nov2011
750 770 2011 12 01dec2011


Is there useful way to construct monthly time series data like the above except for making using of excel?

Thank you