Solved: 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 (1482 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 (1791 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 (1792 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

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.