topic char date yyyymmdd hh:mm:ss into date format in SAS Programming

char date yyyymmdd hh:mm:ss into date format

Geo- — Sun, 18 Nov 2018 13:05:23 GMT

how to replace the old char column into date format?

txn_inf

2015/5/7 9:13:59

2015/2/7 5:43:11

Re: char date yyyymmdd hh:mm:ss into date format

kiranv_ — Sun, 18 Nov 2018 15:56:49 GMT

data have;
txn_inf	= "2015/5/7 9:13:59";
output;
txn_inf	=  "2015/2/7 5:43:11";
output;
run;

data want;
set have;
new_date= datepart(input(txn_inf, ANYDTDTM.));
format new_date date9.;
run;

Re: char date yyyymmdd hh:mm:ss into date format

Geo- — Sun, 18 Nov 2018 23:53:35 GMT

hi~Would you please change it into yyyymmdd hh:mm:ss date format,but not yyyymmdd

Re: char date yyyymmdd hh:mm:ss into date format

Tom — Mon, 19 Nov 2018 01:42:24 GMT

@Geo- wrote:
hi~Would you please change it into yyyymmdd hh:mm:ss date format,but not yyyymmdd

So you actually want a DATETIME value and not a DATE value as your subject line says?

If so then use the ANYDTDTM. informat instead of the ANYDTDTE. informat.

Why would you like to print it using that format? What is wrong with just using the normal DATETIME19. format? Which would look like: 17NOV2018:20:42:01