Solved: Re: Date conversion - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

Date conversion

Posted 07-12-2016 06:54 PM (1165 views)

Hi,

I have a dataset with date as text (2016-01-07 01:48:11.000) I want to change it to DATETIME17. format? any help?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Date conversion

Posted 07-12-2016 07:11 PM (1474 views) | In reply to AZIQ1

In a datastep you would want to create a new variable;

data want;

set have;

dt = input(textdate,anydtdtm32.);

format dt datetime17.;

run;

where textdate is the name of your current variable

View solution in original post

1 REPLY 1

Super User

Super User

Re: Date conversion

Posted 07-12-2016 07:11 PM (1475 views) | In reply to AZIQ1

In a datastep you would want to create a new variable;

data want;

set have;

dt = input(textdate,anydtdtm32.);

format dt datetime17.;

run;

where textdate is the name of your current variable

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!