topic Case Statement with Date in SAS Programming https://communities.sas.com/t5/SAS-Programming/Case-Statement-with-Date/m-p/175860#M33739 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: Courier New;">Hello,</SPAN></P><P></P><P><SPAN style="font-size: 12pt; font-family: Courier New;">I need to write a case statement that would return a specific variable based on the date.&nbsp; I tried the below syntax and is recieving an error.&nbsp; Please advise on the appropiate syntax.</SPAN></P><P></P><P>CASE WHEN a.DT &gt; <STRONG>02Jan2015'd'</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp; THEN b.STAT</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else a.STAT end as "STAT"</P></BODY></HTML> Fri, 20 Feb 2015 00:18:29 GMT thomask23 2015-02-20T00:18:29Z Case Statement with Date https://communities.sas.com/t5/SAS-Programming/Case-Statement-with-Date/m-p/175860#M33739 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: Courier New;">Hello,</SPAN></P><P></P><P><SPAN style="font-size: 12pt; font-family: Courier New;">I need to write a case statement that would return a specific variable based on the date.&nbsp; I tried the below syntax and is recieving an error.&nbsp; Please advise on the appropiate syntax.</SPAN></P><P></P><P>CASE WHEN a.DT &gt; <STRONG>02Jan2015'd'</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp; THEN b.STAT</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else a.STAT end as "STAT"</P></BODY></HTML> Fri, 20 Feb 2015 00:18:29 GMT https://communities.sas.com/t5/SAS-Programming/Case-Statement-with-Date/m-p/175860#M33739 thomask23 2015-02-20T00:18:29Z Re: Case Statement with Date https://communities.sas.com/t5/SAS-Programming/Case-Statement-with-Date/m-p/175861#M33740 <HTML><HEAD></HEAD><BODY><P>untested:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">CASE WHEN a.DT &gt; '<STRONG style="font-style: inherit; font-family: inherit;">02Jan2015'd</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">&nbsp;&nbsp;&nbsp;&nbsp; THEN b.STAT</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else a.STAT end as STAT</P></BODY></HTML> Fri, 20 Feb 2015 00:32:44 GMT https://communities.sas.com/t5/SAS-Programming/Case-Statement-with-Date/m-p/175861#M33740 art297 2015-02-20T00:32:44Z