topic Extract - i want last 3 months in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Extract-i-want-last-3-months/m-p/27761#M203 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an extract which looks like this to make a smaller subset:</P><P></P><P>Turn_Date &gt; Today()-93</P><P></P><P>But what i really want is the current month + the last 3 months ( but the complete data, and not really 93 days )</P><P></P><P>Any tips, help? Is this possible in an extract?</P><P></P><P>Greets</P></BODY></HTML> Fri, 08 Jul 2011 09:13:54 GMT Filipvdr 2011-07-08T09:13:54Z Extract - i want last 3 months https://communities.sas.com/t5/SAS-Data-Management/Extract-i-want-last-3-months/m-p/27761#M203 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an extract which looks like this to make a smaller subset:</P><P></P><P>Turn_Date &gt; Today()-93</P><P></P><P>But what i really want is the current month + the last 3 months ( but the complete data, and not really 93 days )</P><P></P><P>Any tips, help? Is this possible in an extract?</P><P></P><P>Greets</P></BODY></HTML> Fri, 08 Jul 2011 09:13:54 GMT https://communities.sas.com/t5/SAS-Data-Management/Extract-i-want-last-3-months/m-p/27761#M203 Filipvdr 2011-07-08T09:13:54Z Extract - i want last 3 months https://communities.sas.com/t5/SAS-Data-Management/Extract-i-want-last-3-months/m-p/27762#M204 <HTML><HEAD></HEAD><BODY><P> and the answer is:</P><P></P><P>turn_Date &gt;&nbsp; intnx('month',today(),-3)-1;</P></BODY></HTML> Fri, 08 Jul 2011 09:30:37 GMT https://communities.sas.com/t5/SAS-Data-Management/Extract-i-want-last-3-months/m-p/27762#M204 Filipvdr 2011-07-08T09:30:37Z