topic Comparing null and a character value in SAS Programming https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191845#M266164 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need some help with comparision of null and character values. Below is the code.</P><P><STRONG><BR /></STRONG></P><P><STRONG>&nbsp; else if aa and bb and affiliate_id =' ' and aff_id = not null then output;</STRONG></P><P>run;</P></BODY></HTML> Thu, 24 Apr 2014 17:33:07 GMT archana 2014-04-24T17:33:07Z Comparing null and a character value https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191845#M266164 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need some help with comparision of null and character values. Below is the code.</P><P><STRONG><BR /></STRONG></P><P><STRONG>&nbsp; else if aa and bb and affiliate_id =' ' and aff_id = not null then output;</STRONG></P><P>run;</P></BODY></HTML> Thu, 24 Apr 2014 17:33:07 GMT https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191845#M266164 archana 2014-04-24T17:33:07Z Re: Comparing null and a character value https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191846#M266165 <HTML><HEAD></HEAD><BODY><PRE __jive_macro_name="quote" class="jive_text_macro jive_macro_quote"> <P>else if aa and bb and affiliate_id =' ' and aff_id = not null then output;</P> </PRE><P>If I am understanding you properly, you want something like this:</P><P></P><P>else if aa and bb and missing(affiliate_id) and not missing(aff_id) then output;</P></BODY></HTML> Thu, 24 Apr 2014 17:38:36 GMT https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191846#M266165 PaigeMiller 2014-04-24T17:38:36Z Re: Comparing null and a character value https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191847#M266166 <HTML><HEAD></HEAD><BODY><P>Yes. Thank you very much.</P></BODY></HTML> Thu, 24 Apr 2014 17:52:06 GMT https://communities.sas.com/t5/SAS-Programming/Comparing-null-and-a-character-value/m-p/191847#M266166 archana 2014-04-24T17:52:06Z