Good Afternoon,
I am querying a dataset where the date field is stored as a number format, however, the number is dmmyyy, so for example, 1st Apr 2013 shows as as 10413, 31st Dec 2013 shows as 31122013.
Is there any code that would convert this to a recognisable date format so SAS would recognise it was a date and if date9. format was applied would show 01APR2013 and 31DEC2013?
Kind Regards,
cxkev
Have a look at the code below, you need to first convert from numeric to char and then use appropriate informat to make a SAS date from the char variable
Have a look at the code below, you need to first convert from numeric to char and then use appropriate informat to make a SAS date from the char variable
Excellent. Thank you Bruno.
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.