topic Re: date problem in SAS Programming https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/557017#M155236 <P>Excel uses a date system that starts from 1900.</P><P>To convert to SAS date system just subtract 21916 from the Excel date serial.</P><P>&nbsp;</P><P>Not sure what method you are using to import into SAS so try converting the date in Excel prior to importing.</P> Wed, 08 May 2019 07:03:57 GMT JG_ 2019-05-08T07:03:57Z date problem https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/548287#M152023 <DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-header"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-18 lia-quilt-column-left lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-component-message-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV class="first-message"><DIV class="lia-message-view message-uid-548265"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="lia-panel-message-root lia-message-board lia-panel-message lia-js-data-messageUid-548265"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-body"><DIV class="lia-message-body-content"><P>Please help,</P><P>i have this date format in excel&nbsp;&nbsp;</P><TABLE><TBODY><TR><TD>RX_DATE</TD></TR><TR><TD>1/2/2017</TD></TR><TR><TD>1/4/2017</TD></TR><TR><TD>1/2/2018</TD></TR><TR><TD>1/2/2018</TD></TR><TR><TD>1/2/2018</TD></TR><TR><TD>1/2/2018</TD></TR><TR><TD>1/2/2018</TD></TR></TBODY></TABLE><P>when i imported to SAS it looked like this and was in character format</P><TABLE><TBODY><TR><TD>RX_DATE&nbsp;</TD></TR><TR><TD>43626</TD></TR><TR><TD>43146</TD></TR><TR><TD>43146</TD></TR><TR><TD>42826</TD></TR><TR><TD>42586</TD></TR></TBODY></TABLE><P>used this code to change to numeric and to change in date format</P><P>data satratha.TREAT_18;<BR />set satratha.TREAT18;<BR />format rxdate mmddyy10.;<BR />rxdate=input(rx_date, 15.);<BR />run;</P><P>and the changed to&nbsp;</P><TABLE><TBODY><TR><TD>RX_DATE&nbsp;</TD></TR><TR><TD>2/16/2078</TD></TR><TR><TD>2/17/2078</TD></TR><TR><TD>2/18/2078</TD></TR><TR><TD>2/19/2078</TD></TR><TR><TD>2/20/2078</TD></TR></TBODY></TABLE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV> Wed, 03 Apr 2019 17:49:36 GMT https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/548287#M152023 Dhana18 2019-04-03T17:49:36Z Re: date problem https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/548290#M152024 <P>Is this thread a duplicate of your previous --</P> <P>&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Programming/date/m-p/548265" target="_blank">https://communities.sas.com/t5/SAS-Programming/date/m-p/548265</A></P> <P>&nbsp;</P> <P>You could have just edited there</P> Wed, 03 Apr 2019 17:52:03 GMT https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/548290#M152024 novinosrin 2019-04-03T17:52:03Z Re: date problem https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/557017#M155236 <P>Excel uses a date system that starts from 1900.</P><P>To convert to SAS date system just subtract 21916 from the Excel date serial.</P><P>&nbsp;</P><P>Not sure what method you are using to import into SAS so try converting the date in Excel prior to importing.</P> Wed, 08 May 2019 07:03:57 GMT https://communities.sas.com/t5/SAS-Programming/date-problem/m-p/557017#M155236 JG_ 2019-05-08T07:03:57Z