topic Re: DATE Conver in New SAS User

DATE Conver

Spintu — Wed, 16 Oct 2019 13:30:32 GMT

I have a date format like below example. If i want to convert in MMDDYY10. Using DATEPART function it is not working

date='March 29, 2019 5:00:00 AM GMT+01:00';

Do we have any alternate way to convert character date to date format?

JosvanderVelden — Wed, 16 Oct 2019 13:42:54 GMT

Just to verify. The date from your example is a character value and you want to transform it into a sas date (numeric)?

Jagadishkatam — Wed, 16 Oct 2019 13:44:50 GMT

Please try the below code

data have;
date='March 29, 2019 5:00:00 AM GMT+01:00';
newdate=datepart(input(scan(date,1,'G'),anydtdtm.));
format newdate mmddyy10.;
run;

Spintu — Wed, 16 Oct 2019 13:48:40 GMT

Yes , you are right

Spintu — Wed, 16 Oct 2019 13:49:23 GMT

thank you for your quick response.