SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Text Date conversion to datetime

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

Text Date conversion to datetime

Hi all - What I am trying to accomplish is to convert a text date (Open Date) to a DateT  ime (Month End Date).

For example:

OpenDate = 2008-12-12

Below is the code I am using to create a OpenMonth Field

format MonthOpened DateTime22.3;
MonthOpened = dhms(input(OpenDate,yymmdd10.),0,0,0);

OpenMonth = 12DEC2008:00:00:00.000

I keep getting a conversion of the text date to date time instead of 31DEC2008:00:00:00.000

I know that I need to nest the intnx function but I can't seem where to correctly next the function.

intnx('month',MonthOpened,0,'end')

I know that I can do this in multiple steps, but I would like to create one nested function to do the conversion for me.

Thanks!


Accepted Solutions
Solution
‎04-24-2014 10:36 AM
Super Contributor
Posts: 578

Re: Text Date conversion to datetime

Posted in reply to SasGuy614

MonthOpened = dhms(intnx('month',input(OpenDate,yymmdd10.),0,'end'),0,0,0);

View solution in original post


All Replies
Solution
‎04-24-2014 10:36 AM
Super Contributor
Posts: 578

Re: Text Date conversion to datetime

Posted in reply to SasGuy614

MonthOpened = dhms(intnx('month',input(OpenDate,yymmdd10.),0,'end'),0,0,0);

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 311 views
  • 0 likes
  • 2 in conversation