topic Re: converting dates to numeric in SAS Programming https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164249#M300307 <HTML><HEAD></HEAD><BODY><P>I do not understand, the data is imported from excel, the variable name is date.</P><P>Just as you said I need number equivalent to the date then please try this.</P></BODY></HTML> Mon, 10 Nov 2014 17:50:28 GMT desireatem 2014-11-10T17:50:28Z converting dates to numeric https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164247#M300305 <HTML><HEAD></HEAD><BODY><P>How do I convert dates of this form 10/27/2006 to numeric? some dates are 2/2/2006?</P></BODY></HTML> Mon, 10 Nov 2014 17:35:55 GMT https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164247#M300305 desireatem 2014-11-10T17:35:55Z Re: converting dates to numeric https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164248#M300306 <HTML><HEAD></HEAD><BODY><P>If I understood it correctly, you need number equivalent to the date then please try this.</P><P></P><P>data have;</P><P>input date mmddyy10.;</P><P>format&nbsp; date mmddyy10.;</P><P><STRONG>date_number=date;</STRONG></P><P>datalines;</P><P>10/27/2006</P><P>;</P></BODY></HTML> Mon, 10 Nov 2014 17:41:10 GMT https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164248#M300306 stat_sas 2014-11-10T17:41:10Z Re: converting dates to numeric https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164249#M300307 <HTML><HEAD></HEAD><BODY><P>I do not understand, the data is imported from excel, the variable name is date.</P><P>Just as you said I need number equivalent to the date then please try this.</P></BODY></HTML> Mon, 10 Nov 2014 17:50:28 GMT https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164249#M300307 desireatem 2014-11-10T17:50:28Z Re: converting dates to numeric https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164250#M300308 <HTML><HEAD></HEAD><BODY><P>What is the type of date variable? Are you looking to convert char date variable into numeric or just need to know number which represents 10/27/2006?</P></BODY></HTML> Mon, 10 Nov 2014 18:08:26 GMT https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164250#M300308 stat_sas 2014-11-10T18:08:26Z Re: converting dates to numeric https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164251#M300309 <HTML><HEAD></HEAD><BODY><P>A number 10/27/2006</P></BODY></HTML> Mon, 10 Nov 2014 18:16:33 GMT https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164251#M300309 desireatem 2014-11-10T18:16:33Z Re: converting dates to numeric https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164252#M300310 <HTML><HEAD></HEAD><BODY><P>What is the desired output?</P></BODY></HTML> Mon, 10 Nov 2014 18:22:46 GMT https://communities.sas.com/t5/SAS-Programming/converting-dates-to-numeric/m-p/164252#M300310 stat_sas 2014-11-10T18:22:46Z