https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720886#M27742 <P>Dear all,</P> <P>&nbsp;</P> <P>I have various proc sql programs that each contains a clause ' When date =&nbsp;'30Mar2017'D'.</P> <P>&nbsp;</P> <P>How can I optimize the process by stating at the beginning the date and not changing the date within each proc sql?</P> <P>&nbsp;</P> <P>Thank you.&nbsp;</P> Mon, 22 Feb 2021 11:53:24 GMT cmemtsa 2021-02-22T11:53:24Z https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720886#M27742 <P>Dear all,</P> <P>&nbsp;</P> <P>I have various proc sql programs that each contains a clause ' When date =&nbsp;'30Mar2017'D'.</P> <P>&nbsp;</P> <P>How can I optimize the process by stating at the beginning the date and not changing the date within each proc sql?</P> <P>&nbsp;</P> <P>Thank you.&nbsp;</P> Mon, 22 Feb 2021 11:53:24 GMT https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720886#M27742 cmemtsa 2021-02-22T11:53:24Z https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720892#M27743 <P>Use a macro variable:</P> <PRE><CODE class=" language-sas">%let refdate=%sysfunc(inputn(30mar2017,date9.));</CODE></PRE> <P>and later</P> <PRE><CODE class=" language-sas">when date = &amp;refdate.</CODE></PRE> Mon, 22 Feb 2021 12:16:53 GMT https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720892#M27743 Kurt_Bremser 2021-02-22T12:16:53Z https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720893#M27744 <P>Thank you!!!</P> Mon, 22 Feb 2021 12:26:35 GMT https://communities.sas.com/t5/New-SAS-User/How-to-reference-once-a-date/m-p/720893#M27744 cmemtsa 2021-02-22T12:26:35Z