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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.