topic Re: seperate date and time in SAS Programming

seperate date and time

Smitha9 — Thu, 18 Aug 2022 23:26:37 GMT

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

Re: seperate date and time

japelin — Thu, 18 Aug 2022 23:51:10 GMT

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;

Re: seperate date and time

japelin — Thu, 18 Aug 2022 23:56:34 GMT

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;