https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-SQL-CASE-STATEMENT/m-p/272256#M18900 <P>Syntax looks ok, but your parentheses are in the wrong place and you are missing the END keyword.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">case when (x=1) then '01jul2009'd end as DATE1 </CODE></PRE> <P>&nbsp;</P> Sat, 21 May 2016 17:03:29 GMT Tom 2016-05-21T17:03:29Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-SQL-CASE-STATEMENT/m-p/272249#M18898 <P>I would ask about how can I write date in case statement after then. For example, I tried this context &nbsp;(case when x=1 then '01jul2009'd),</P><P>but, unfortunately, it dosen"t work. &nbsp;</P> Sat, 21 May 2016 16:06:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-SQL-CASE-STATEMENT/m-p/272249#M18898 hamzah 2016-05-21T16:06:40Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-SQL-CASE-STATEMENT/m-p/272256#M18900 <P>Syntax looks ok, but your parentheses are in the wrong place and you are missing the END keyword.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">case when (x=1) then '01jul2009'd end as DATE1 </CODE></PRE> <P>&nbsp;</P> Sat, 21 May 2016 17:03:29 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-SQL-CASE-STATEMENT/m-p/272256#M18900 Tom 2016-05-21T17:03:29Z