BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
NK29
Fluorite | Level 6

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
1 ACCEPTED SOLUTION

Accepted Solutions
andreas_lds
Jade | Level 19

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;

View solution in original post

3 REPLIES 3
andreas_lds
Jade | Level 19

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
Lapis Lazuli | Level 10

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 5977 views
  • 0 likes
  • 4 in conversation