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

[UcheOkoro]

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 · Accepted solution]

Have you tried:

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

Art, CEO, AnalystFinder.com

[UcheOkoro]

Thank you so much for your prompt and helpful answer.