Hi I have FL_DT in the format. I am trying to covert it to sysdate format . could you please help?
|
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;
Use the datepart() function to extract the date from the datetime value. After doing that, you can apply the date9. format.
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;
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);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.