https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/IF-conditions-in-SQL/m-p/6176#M597 This is Microsoft SQL Server Query, can SAS SQL can do something like this? Mon, 07 Jan 2008 10:16:37 GMT deleted_user 2008-01-07T10:16:37Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/IF-conditions-in-SQL/m-p/6176#M597 This is Microsoft SQL Server Query, can SAS SQL can do something like this? Mon, 07 Jan 2008 10:16:37 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/IF-conditions-in-SQL/m-p/6176#M597 deleted_user 2008-01-07T10:16:37Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/IF-conditions-in-SQL/m-p/6177#M598 Use case expressions.which works similarly as if in sql server.<BR /> <BR /> select <COLUMNS>..<N><BR /> ,case when <CONDITION> then <STATEMENT>|<EXPRESSION><BR /> ...<WHEN-N><BR /> else <STATEMENT>|<EXPRESSION> end<BR /> from <TABLE name=""><BR /> quit;</TABLE></EXPRESSION></STATEMENT></WHEN-N></EXPRESSION></STATEMENT></CONDITION></N></COLUMNS> Tue, 27 Jan 2009 12:05:10 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/IF-conditions-in-SQL/m-p/6177#M598 deleted_user 2009-01-27T12:05:10Z