DATA Step, Macro, Functions and more

DATETIME FORMATS

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

DATETIME FORMATS

 

 

Hello,

 

I have a datetime format like shown below and have difficulty changing it to a date9. format.

Format is datetime22.3 and informat is also datetime22.3

 

ID     Tken_date

110   12DEC2015:00:00:00.000

111   13DEC2015:00:00:00.000

112   14DEC2015:00:00:00.000

113   15DEC2015:00:00:00.000

 

 

WANT

ID     Tken_date

110   12DEC2015

111   13DEC2015

112   14DEC2015

113   15DEC2015

 

Thanks

 

 

 

 


Accepted Solutions
Solution
‎08-18-2016 11:01 AM
Super User
Posts: 10,516

Re: DATETIME FORMATS

If you are not actually using the time part I would suggest converting to a date and assigning the desired format:

 

data want;

    set have;

    Tken_date=datepart(Tken_date);

     format Tken_date date9.;

run;

View solution in original post


All Replies
Solution
‎08-18-2016 11:01 AM
Super User
Posts: 10,516

Re: DATETIME FORMATS

If you are not actually using the time part I would suggest converting to a date and assigning the desired format:

 

data want;

    set have;

    Tken_date=datepart(Tken_date);

     format Tken_date date9.;

run;

Super Contributor
Posts: 1,040

Re: DATETIME FORMATS

OMG!, I was trying that and other PUT, INPUT combinations all this while but it throwed up some negative numbers.

It works now though ...thansk a ton...

 

Regards

Super User
Posts: 17,868

Re: DATETIME FORMATS

DTDATE9

 

format variable_name dtdate9.;

☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 269 views
  • 1 like
  • 3 in conversation