topic SAS case statement question in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-case-statement-question/m-p/149590#M11745 <HTML><HEAD></HEAD><BODY><P>In this code:</P><P></P><P>case when strip(col1 ) then "DIGIT" </P><P>when anyalpha( strip(col1)) then "ALPHA" </P><P>else "DIGIT" </P><P></P><P>Under what condition will it evaluate to "DIGIT"? In case col1 = null?</P></BODY></HTML> Wed, 07 May 2014 19:20:13 GMT eagles_dare13 2014-05-07T19:20:13Z SAS case statement question https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-case-statement-question/m-p/149590#M11745 <HTML><HEAD></HEAD><BODY><P>In this code:</P><P></P><P>case when strip(col1 ) then "DIGIT" </P><P>when anyalpha( strip(col1)) then "ALPHA" </P><P>else "DIGIT" </P><P></P><P>Under what condition will it evaluate to "DIGIT"? In case col1 = null?</P></BODY></HTML> Wed, 07 May 2014 19:20:13 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-case-statement-question/m-p/149590#M11745 eagles_dare13 2014-05-07T19:20:13Z Re: SAS case statement question https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-case-statement-question/m-p/149591#M11746 <HTML><HEAD></HEAD><BODY><P>Without a case-operand, the when-expressions must resolve to logical values. Your first expression (strip(col1)) evaluates to a character value. It will be considered FALSE when the result is missing and TRUE otherwise. When it is FALSE then the second condition (anyalpha(strip(col1))) will also be false since strip(col1) is missing and the else-expression will be returned. So, I think that this expression will always evaluate to DIGIT. </P><P>What is your intent?</P><P></P><P>PG</P></BODY></HTML> Wed, 07 May 2014 20:22:14 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-case-statement-question/m-p/149591#M11746 PGStats 2014-05-07T20:22:14Z