topic Re: Converting ddmmyyyy:hh:mm:ss to date9 in SAS Programming

Converting ddmmyyyy:hh:mm:ss to date9

NK29 — Wed, 18 Jul 2018 07:31:18 GMT

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

Re: Converting ddmmyyyy:hh:mm:ss to date9

Kurt_Bremser — Wed, 18 Jul 2018 07:49:50 GMT

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

Re: Converting ddmmyyyy:hh:mm:ss to date9

andreas_lds — Wed, 18 Jul 2018 07:51:27 GMT

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;

Re: Converting ddmmyyyy:hh:mm:ss to date9

pau13rown — Wed, 18 Jul 2018 07:52:35 GMT

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);