topic Re: dates difference in SAS Programming https://communities.sas.com/t5/SAS-Programming/dates-difference/m-p/94790#M19978 <HTML><HEAD></HEAD><BODY><P>First, when you say format, do you mean that the dates are stored as CHAR? If they are stored as SAS dates, the format doesn't matter in the join logic.</P><P></P><P>Join criteria:</P><P>a.cust_id = b.cust_id and b.date between a.date and a.date -30</P><P></P><P>Be aware that you will be noted of that SAS can't optimize these kind of criteria, but if your data isn't too large, it shouldn't be a problem.</P></BODY></HTML> Thu, 26 Sep 2013 15:40:16 GMT LinusH 2013-09-26T15:40:16Z dates difference https://communities.sas.com/t5/SAS-Programming/dates-difference/m-p/94789#M19977 <HTML><HEAD></HEAD><BODY><P>There are two datasets A &amp;B.The common field between them is cust_id.</P><P>Table A have the date filed in format 2013-09-26&nbsp;&nbsp; and table B date filed in format 20130926</P><P>How to get records from table B&nbsp; that are 30days prior to date in table A for the same cust id?</P></BODY></HTML> Thu, 26 Sep 2013 15:00:10 GMT https://communities.sas.com/t5/SAS-Programming/dates-difference/m-p/94789#M19977 SASPhile 2013-09-26T15:00:10Z Re: dates difference https://communities.sas.com/t5/SAS-Programming/dates-difference/m-p/94790#M19978 <HTML><HEAD></HEAD><BODY><P>First, when you say format, do you mean that the dates are stored as CHAR? If they are stored as SAS dates, the format doesn't matter in the join logic.</P><P></P><P>Join criteria:</P><P>a.cust_id = b.cust_id and b.date between a.date and a.date -30</P><P></P><P>Be aware that you will be noted of that SAS can't optimize these kind of criteria, but if your data isn't too large, it shouldn't be a problem.</P></BODY></HTML> Thu, 26 Sep 2013 15:40:16 GMT https://communities.sas.com/t5/SAS-Programming/dates-difference/m-p/94790#M19978 LinusH 2013-09-26T15:40:16Z