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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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: