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);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: