https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28469#M1105 I have a DATETIME variable that looks like 15NOV2007:09:08:00. I want to separate the Date and Time into separate variables. How do I do this while keeping the formatting. Thanks. Mon, 30 Jun 2008 18:46:22 GMT deleted_user 2008-06-30T18:46:22Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28469#M1105 I have a DATETIME variable that looks like 15NOV2007:09:08:00. I want to separate the Date and Time into separate variables. How do I do this while keeping the formatting. Thanks. Mon, 30 Jun 2008 18:46:22 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28469#M1105 deleted_user 2008-06-30T18:46:22Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28470#M1106 Use the DATEPART and TIMEPART functions to extract the pertinent pieces and then apply the appropriate formats to the resulting variables. Tue, 01 Jul 2008 01:55:14 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28470#M1106 Doc_Duke 2008-07-01T01:55:14Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28471#M1107 Thanks. I found the function about an hour after I posted. Tue, 01 Jul 2008 14:17:24 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Separate-Date-Time-variable-to-Date-and-Time-variables/m-p/28471#M1107 deleted_user 2008-07-01T14:17:24Z