https://communities.sas.com/t5/SAS-Procedures/Converting-character-to-Numeric-date/m-p/44114#M11629 input(substr(year,1,4),4.); Sun, 04 Jul 2010 03:10:06 GMT Patrick 2010-07-04T03:10:06Z https://communities.sas.com/t5/SAS-Procedures/Converting-character-to-Numeric-date/m-p/44113#M11628 I have a bunch of data with the dates in years, for example,<BR /> 1921-22,<BR /> 1922-23,<BR /> 1923-24.<BR /> i tried to convert them to the numeric year which will only show the first 4 numeric # as the year, for example, the date should be like,<BR /> 1921,<BR /> 1922,<BR /> 1923.<BR /> i used input(substr(year,1,4),f4.0);<BR /> it's saying Statement is not valid or it is used out of proper order.<BR /> thanks,<BR /> Y Sun, 04 Jul 2010 01:42:50 GMT https://communities.sas.com/t5/SAS-Procedures/Converting-character-to-Numeric-date/m-p/44113#M11628 deleted_user 2010-07-04T01:42:50Z https://communities.sas.com/t5/SAS-Procedures/Converting-character-to-Numeric-date/m-p/44114#M11629 input(substr(year,1,4),4.); Sun, 04 Jul 2010 03:10:06 GMT https://communities.sas.com/t5/SAS-Procedures/Converting-character-to-Numeric-date/m-p/44114#M11629 Patrick 2010-07-04T03:10:06Z