DATE Conver

[Spintu]

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]

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

[Spintu]

Yes , you are right

[Jagadishkatam · Accepted solution]

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]

thank you for your quick response.