Desktop productivity for business analysts and programmers

Converting Integers into Date

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Converting Integers into Date

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?


Accepted Solutions
Solution
‎04-28-2016 09:55 PM
Respected Advisor
Posts: 3,124

Re: Converting Integers into Date

if old_date is number, try this:

new_date='22mar2010'd+old_date;

 

 

View solution in original post


All Replies
Solution
‎04-28-2016 09:55 PM
Respected Advisor
Posts: 3,124

Re: Converting Integers into Date

if old_date is number, try this:

new_date='22mar2010'd+old_date;

 

 

New Contributor
Posts: 2

Re: Converting Integers into Date

Thanks a lot, it worked Smiley Happy

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 219 views
  • 0 likes
  • 2 in conversation