Good Afternoon
Im wondering if there is any way to convert a Text date that looks like 02JAN2017
Since im simply reading a dataset that has the date stored in this manor, im extracting it using a select statement, if at possible to convert or substring it from there and convert it, would be Best for me newbie self 🙂
any help is greatly appreciated
happy friday!
In a data step, since you have already read the data:
SASDate = input(yourdate, date9.);
format SASdate date9. ; /* or any of the other date formats humans like*/
in sql it would be
input(yourdate,date9.) as SASDate format=date9.
Best would be to read the data initially.
In a data step, since you have already read the data:
SASDate = input(yourdate, date9.);
format SASdate date9. ; /* or any of the other date formats humans like*/
in sql it would be
input(yourdate,date9.) as SASDate format=date9.
Best would be to read the data initially.
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.