topic I am trying to extract a date variable from a variable that date and time (eg 12Jul19:12:34:00) in SAS Programming

I am trying to extract a date variable from a variable that date and time (eg 12Jul19:12:34:00)

UcheOkoro — Tue, 31 Mar 2020 23:10:24 GMT

I am trying to extract a date variable(eg. 12Jul19) from a variable that date and time (eg. 12Jul19:12:34:00).

I have tried this code but it is not working .

DATA Mydata2;
SET Mydata;
date = MDY(Arrival);
RUN;

I sincerely appreciate your help.

Thank you.

art297 — Tue, 31 Mar 2020 23:39:33 GMT

Have you tried:

DATA Mydata2;
  SET Mydata;
  date = datepart(Arrival);
  format date date9.;
RUN;

Art, CEO, AnalystFinder.com

UcheOkoro — Wed, 01 Apr 2020 01:10:15 GMT

Thank you so much for your prompt and helpful answer.