Hi all,

I am wondering if it is possible to generate a variable in the format of ith day of the year from a date variable. I have been reading about working with date variables in Stata, but have yet to find a solution to this problem.

So, using a small subset of the data for an example, I have:

date
07oct2003
01apr2005
07oct2003
30oct2003
01apr2005
01apr2005
29dec2003
30oct2003
30oct2003
01apr2005

And I am hoping to create a variable with values of:

day_of_year
280
91
280
303
91
91
363
303
303
91

I understand that this is complicated by leap years (2000, 2004, etc.), but I am hoping that Stata can automatically account for that somehow...
Any advice you might be able to offer would be greatly appreciated!

Best wishes,
Matt