topic Re: Convert Charater AM PM to Datetime format. in New SAS User

Convert Charater AM PM to Datetime format.

mlogan — Sun, 12 Jan 2020 02:11:47 GMT

Hi there,

I have the date time format as '1/11/2017 8:00:41 AM +00:00' and it is in character format. I don't there this '+00:00' came from, but in my all data they all end with '+00:00', so I really don't care.

can someone help me convert it to Datetime format like '1/11/2017 8:00:41 AM' please?

DATA Have;
Date_Time='1/11/2017 8:00:41 AM +00:00';
RUN;

Thanks.

Re: Convert Charater AM PM to Datetime format.

novinosrin — Sun, 12 Jan 2020 02:36:51 GMT


DATA Have;
Date_Time='1/11/2017 8:00:41 AM +00:00';
RUN;

data want;
 set have;
 want_date=input(date_time,mdyampm23.);
 format want_date  DATEAMPM. ;
run;

Re: Convert Charater AM PM to Datetime format.

dennis_oz — Wed, 03 Jun 2020 06:49:52 GMT

@novinosrin @mlogan

Hi I have a similar question . How to convert 28-APR-20 02.56.42.897749 PM ( length is 28 char) to DATETIME ? Please can you help

Re: Convert Charater AM PM to Datetime format.

novinosrin — Thu, 04 Jun 2020 20:09:00 GMT

Hi @dennis_oz Would the below suffice?

data w;
 have='28-APR-20 02.56.42.897749 PM';
 want=input(have, datetime30.);
 format want datetime30.;
run;