topic Re: Converting Integers into Date in SAS Enterprise Guide

Converting Integers into Date

Gurjot — Fri, 29 Apr 2016 01:36:39 GMT

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?

Re: Converting Integers into Date

Haikuo — Fri, 29 Apr 2016 01:42:09 GMT

if old_date is number, try this:

new_date='22mar2010'd+old_date;

Re: Converting Integers into Date

Gurjot — Fri, 29 Apr 2016 01:54:48 GMT

Thanks a lot, it worked 🙂