https://communities.sas.com/t5/SAS-Procedures/date/m-p/46480#M12383 Hello SAS83,<BR /> <BR /> This is a possible solution:<BR /> [pre]<BR /> data i;<BR /> dt="19JAN2006:17:14:33.072000"dt;<BR /> year=YEAR(DATEPART(dt));<BR /> format dt datetime.;<BR /> run;<BR /> [/pre]<BR /> Sincerely,<BR /> SPR Thu, 07 Apr 2011 16:23:44 GMT SPR 2011-04-07T16:23:44Z https://communities.sas.com/t5/SAS-Procedures/date/m-p/46478#M12381 how to strip out year from this field.<BR /> <BR /> It is in datetime format.<BR /> <BR /> 19JAN2006:17:14:33.072000<BR /> <BR /> Thanks in advance.. Thu, 07 Apr 2011 15:55:53 GMT https://communities.sas.com/t5/SAS-Procedures/date/m-p/46478#M12381 SAS83 2011-04-07T15:55:53Z https://communities.sas.com/t5/SAS-Procedures/date/m-p/46479#M12382 You can use the DATEPART function. <BR /> YEAR=DATEPART(yourdate);<BR /> <BR /> I think that is the right syntax. Thu, 07 Apr 2011 16:04:31 GMT https://communities.sas.com/t5/SAS-Procedures/date/m-p/46479#M12382 yaswoman 2011-04-07T16:04:31Z https://communities.sas.com/t5/SAS-Procedures/date/m-p/46480#M12383 Hello SAS83,<BR /> <BR /> This is a possible solution:<BR /> [pre]<BR /> data i;<BR /> dt="19JAN2006:17:14:33.072000"dt;<BR /> year=YEAR(DATEPART(dt));<BR /> format dt datetime.;<BR /> run;<BR /> [/pre]<BR /> Sincerely,<BR /> SPR Thu, 07 Apr 2011 16:23:44 GMT https://communities.sas.com/t5/SAS-Procedures/date/m-p/46480#M12383 SPR 2011-04-07T16:23:44Z https://communities.sas.com/t5/SAS-Procedures/date/m-p/46481#M12384 Thank you !! Thu, 07 Apr 2011 17:15:23 GMT https://communities.sas.com/t5/SAS-Procedures/date/m-p/46481#M12384 SAS83 2011-04-07T17:15:23Z