Converting Integers into Date

[Gurjot]

I am using SAS enterprise Guide for one of my projects. We have the day number as a column in the data and we know the First day is taken as 23 March 2010. But the column we have is numbered from 1 to 711.

Is there a was to convert this column to dates, so for 1 it would be 23 March 2010, for 2 it will be 24 March 2010 and so on?

[Haikuo · Accepted solution]

if old_date is number, try this:

new_date='22mar2010'd+old_date;

[Gurjot]

Thanks a lot, it worked 🙂