https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compare-two-date-in-a-if-statement/m-p/691388#M37298 <P>Without quotes, SEP2020 is a variable name for the data step compiler. You have to enclose the macro variables in double quotes to make them strings.</P> Tue, 13 Oct 2020 20:31:32 GMT Kurt_Bremser 2020-10-13T20:31:32Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compare-two-date-in-a-if-statement/m-p/691381#M37295 <P>%let File1Date=SEP2020;<BR />%let File2Date=OCT2020;<BR />%LET Nobs1=5;<BR />%LET Nobs2=5;</P> <P>Data _null_;</P> <P>if input(&amp;File1Date.,monyy7.) ne input(&amp;File2Date.,monyy7.) then call symputx('Nobs1',0);<BR />run;<BR />%put &amp;Nobs1. &amp;Nobs2. ;</P> Tue, 13 Oct 2020 20:15:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compare-two-date-in-a-if-statement/m-p/691381#M37295 alepage 2020-10-13T20:15:08Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compare-two-date-in-a-if-statement/m-p/691388#M37298 <P>Without quotes, SEP2020 is a variable name for the data step compiler. You have to enclose the macro variables in double quotes to make them strings.</P> Tue, 13 Oct 2020 20:31:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compare-two-date-in-a-if-statement/m-p/691388#M37298 Kurt_Bremser 2020-10-13T20:31:32Z