https://communities.sas.com/t5/SAS-Procedures/To-check-overlapping-data-time/m-p/27386#M6247 ********Sorry, Please Ignore This**************<BR /> <BR /> <BR /> Hi everyone,<BR /> <BR /> I am trying to write a code to seperate records with overlapping dates. But I have datetime in iso format (2009-10-09T10:00). I seperated the date and time an concatenated them into a different character variable(09OCT2009:10:00). How do I convert this into a numeric variable where I can use operators such as less than and Greater than.<BR /> <BR /> Thanks Message was edited by: madhu Tue, 08 Dec 2009 13:53:01 GMT madhu 2009-12-08T13:53:01Z https://communities.sas.com/t5/SAS-Procedures/To-check-overlapping-data-time/m-p/27386#M6247 ********Sorry, Please Ignore This**************<BR /> <BR /> <BR /> Hi everyone,<BR /> <BR /> I am trying to write a code to seperate records with overlapping dates. But I have datetime in iso format (2009-10-09T10:00). I seperated the date and time an concatenated them into a different character variable(09OCT2009:10:00). How do I convert this into a numeric variable where I can use operators such as less than and Greater than.<BR /> <BR /> Thanks Message was edited by: madhu Tue, 08 Dec 2009 13:53:01 GMT https://communities.sas.com/t5/SAS-Procedures/To-check-overlapping-data-time/m-p/27386#M6247 madhu 2009-12-08T13:53:01Z https://communities.sas.com/t5/SAS-Procedures/To-check-overlapping-data-time/m-p/27387#M6248 Hi:<BR /> To change a character variable to a numeric variable, you can use the INPUT function. Since your character variable represents a date/time, you can use a date/time INFORMAT with the INPUT function to create a numeric variable that represents the number of seconds since midnight Jan 1, 1960. <BR /> <BR /> There have been many previous posts in this forum and others on how to convert character date variables to numeric variables. If you either look in the documentation on INPUT and INFORMAT or search the forum postings, you should find some useful examples.<BR /> <BR /> cynthia Tue, 08 Dec 2009 14:14:46 GMT https://communities.sas.com/t5/SAS-Procedures/To-check-overlapping-data-time/m-p/27387#M6248 Cynthia_sas 2009-12-08T14:14:46Z