Converting ddmmyyyy:hh:mm:ss to date9

[NK29]

Hi I have FL_DT in the format. I am trying to covert it to sysdate format . could you please help?

02JUN2018:00:00:00

[Kurt_Bremser]

Use the datepart() function to extract the date from the datetime value. After doing that, you can apply the date9. format.

[andreas_lds · Accepted solution]

Is FL_DT a string or a numeric variable containing a sas-datetime-value?

data bob;
  FL_DT = '02JUN2018:00.00.00'dt;
  FL_Date = datepart(FL_DT);

  format FL_DT datetime. FL_Date date9.;
run;

[pau13rown]

it's a text variable? if so, maybe:

format newdate date9.;

  day=input(substr(olddate,1,2),2.);
  monthtxt=substr(olddate,4,3);
  if monthtxt ne '' then month=month(input("01"||substr(monthtxt,1,3)||"2000",date9.));
  year=input(substr(olddate,8,4),4.);
  if day ne . and month ne . and year ne . then newdate=mdy(month,day,year);