https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416014#M120 Thanks for your response.<BR />I will try this. Fri, 24 Nov 2017 13:19:25 GMT Laxesh7 2017-11-24T13:19:25Z https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416010#M118 Hello,<BR />May i know how can i use if condition in Query builder?<BR />My scenario is i want to create new column based on some conditions.<BR />Can anyone help me step by step.?<BR />thanks in advace. Fri, 24 Nov 2017 13:08:45 GMT https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416010#M118 Laxesh7 2017-11-24T13:08:45Z https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416012#M119 <P>Hi,</P> <P>&nbsp;</P> <P>Because Query builder is based on SQL, therefore you'll need to use the <A title="CASE Statement" href="http://www.lexjansen.com/wuss/2011/coders/Papers_Lafler_K_72492.pdf" target="_self">CASE Statement</A> for Conditional Processing.</P> <P>&nbsp;</P> <P>Hope this helps,</P> <P>Ahmed</P> Fri, 24 Nov 2017 13:15:39 GMT https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416012#M119 AhmedAl_Attar 2017-11-24T13:15:39Z https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416014#M120 Thanks for your response.<BR />I will try this. Fri, 24 Nov 2017 13:19:25 GMT https://communities.sas.com/t5/Developers/Use-If-condition-in-query-builder/m-p/416014#M120 Laxesh7 2017-11-24T13:19:25Z