Hi check below link if you can locate solution for your problem http://www.lexjansen.com/nesug/nesug10/ph/ph11.pdf @buddha_d wrote: Can someone help me with the code to convert this numberic date format to ISO8601 fomat (like17OCT2016 2 time 9:10:04 to 2016-10-17T09:10:04), but I want to have a generic code even for missing date or month or both . I am trying to Converting Non-Imputed Partial Dates for a sdtm dataset. how to delete the wrong numbers for time notation (like hours upto 24, minutes upto 60, upto 60 sec etc) eg: 2016-10-17T09:10:04 2016-10--T09:10:04 2016----T09:10:04 2016-10-17T-:10:04 2016-10--T09:10:04 2016----T09:10:04 2016-10-17T00:10:04 2016-10-17T09:00:04 2016-10-17T09:10:00 please correct me if this notation is wrong in sdtm ISO 8601 fomat? @buddha_d wrote: Can someone help me with the code to convert this numberic date format to ISO8601 fomat (like17OCT2016 2 time 9:10:04 to 2016-10-17T09:10:04), but I want to have a generic code even for missing date or month or both . I am trying to Converting Non-Imputed Partial Dates for a sdtm dataset. how to delete the wrong numbers for time notation (like hours upto 24, minutes upto 60, upto 60 sec etc) eg: 2016-10-17T09:10:04 2016-10--T09:10:04 2016----T09:10:04 2016-10-17T-:10:04 2016-10--T09:10:04 2016----T09:10:04 2016-10-17T00:10:04 2016-10-17T09:00:04 2016-10-17T09:10:00 please correct me if this notation is wrong in sdtm ISO 8601 fomat?
... View more