topic convert numeric to datetimew.d in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/convert-numeric-to-datetimew-d/m-p/136777#M36877 <HTML><HEAD></HEAD><BODY><P>I would like to convert a SAS numeric to datetime22.3. However, as my original value does not have the time values (only dates) how, do I get my new format to accurately reflect the date and automatically add zeros for the time part. </P><P>What SAS statement should I use to produce the below datetime22.3 format if I have the SAS numeric code as my starting point?</P><P></P><P>SAS numeric = 18453&nbsp; --&gt; format mmddy10 = 07/10/2010 --&gt; format datetime22.3 =10JUL2010:00:00:00.000</P></BODY></HTML> Thu, 09 Jan 2014 22:50:13 GMT sophia_SAS 2014-01-09T22:50:13Z convert numeric to datetimew.d https://communities.sas.com/t5/SAS-Procedures/convert-numeric-to-datetimew-d/m-p/136777#M36877 <HTML><HEAD></HEAD><BODY><P>I would like to convert a SAS numeric to datetime22.3. However, as my original value does not have the time values (only dates) how, do I get my new format to accurately reflect the date and automatically add zeros for the time part. </P><P>What SAS statement should I use to produce the below datetime22.3 format if I have the SAS numeric code as my starting point?</P><P></P><P>SAS numeric = 18453&nbsp; --&gt; format mmddy10 = 07/10/2010 --&gt; format datetime22.3 =10JUL2010:00:00:00.000</P></BODY></HTML> Thu, 09 Jan 2014 22:50:13 GMT https://communities.sas.com/t5/SAS-Procedures/convert-numeric-to-datetimew-d/m-p/136777#M36877 sophia_SAS 2014-01-09T22:50:13Z Re: convert numeric to datetimew.d https://communities.sas.com/t5/SAS-Procedures/convert-numeric-to-datetimew-d/m-p/136778#M36878 <HTML><HEAD></HEAD><BODY><P>Convert the SAS date value to a SAS datetime value like so:</P><P></P><P><STRONG>format dt datetime22.3;</STRONG></P><P><STRONG>dt = dhms(myDate, 0, 0, 0);</STRONG></P><P></P><P>PG</P></BODY></HTML> Thu, 09 Jan 2014 23:12:24 GMT https://communities.sas.com/t5/SAS-Procedures/convert-numeric-to-datetimew-d/m-p/136778#M36878 PGStats 2014-01-09T23:12:24Z