https://communities.sas.com/t5/SAS-Programming/Macro-to-get-last-90-days/m-p/410457#M100281 <P>The macro code is unnecessary. Just use today() - 90.</P> <P>Your problem might be that DAYDATE is not really a SAS date variable.</P> Fri, 03 Nov 2017 20:48:49 GMT Kurt_Bremser 2017-11-03T20:48:49Z https://communities.sas.com/t5/SAS-Programming/Macro-to-get-last-90-days/m-p/410455#M100280 <P><FONT face="Courier New" size="3">I am trying to write a&nbsp;macro that contains the following line to&nbsp;get the last 90 days from my temporary data set. Do I need to use %eval and %sysfunc in the macro for it to work or can I just use today()-90? </FONT></P><P>&nbsp;</P><P><FONT face="Courier New" size="3">t1.DAYDATE &gt; </FONT><FONT color="#0000ff" face="Courier New" size="3">%eval</FONT><FONT face="Courier New" size="3">(</FONT><FONT color="#0000ff" face="Courier New" size="3">%sysfunc</FONT><FONT face="Courier New" size="3">(today())-</FONT><STRONG><FONT color="#008080" face="Courier New" size="3">90</FONT></STRONG><FONT face="Courier New" size="3">)</FONT></P> Fri, 03 Nov 2017 21:50:08 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-get-last-90-days/m-p/410455#M100280 kmcnulty 2017-11-03T21:50:08Z https://communities.sas.com/t5/SAS-Programming/Macro-to-get-last-90-days/m-p/410457#M100281 <P>The macro code is unnecessary. Just use today() - 90.</P> <P>Your problem might be that DAYDATE is not really a SAS date variable.</P> Fri, 03 Nov 2017 20:48:49 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-get-last-90-days/m-p/410457#M100281 Kurt_Bremser 2017-11-03T20:48:49Z