seperate date and time

[Smitha9]

I have a dataset:

Date:

30AUG2022:11:15:00.000

I want a separate variables for Date and Time 

Date                Time

30AUG2022   11:15:00.000

thank you in advance

[japelin]

Is Date variable numeric?

Then use these.

data _null_;
  Date='30AUG2022:11:15:00.000'dt;
  da=datepart(Date);
  tm=timepart(Date);
  format da date9.
         tm time12.4;
run;

[japelin · Accepted solution]

If Date is character variable, use anydtdtm informat for converting to date value.

data _null_;
  Date='30AUG2022:11:15:00.000';
  dt=input(Date,anydtdtm22.);
  da=datepart(dt);
  tm=timepart(dt);
  format da date9.
         tm time12.4;
run;