topic Re: Filter by number of characters in SAS Programming https://communities.sas.com/t5/SAS-Programming/Filter-by-number-of-characters/m-p/692806#M211130 <PRE><CODE class=" language-sas">data want; set have; where length(user_id) = 8; run;</CODE></PRE> Tue, 20 Oct 2020 10:34:26 GMT Kurt_Bremser 2020-10-20T10:34:26Z Filter by number of characters https://communities.sas.com/t5/SAS-Programming/Filter-by-number-of-characters/m-p/692803#M211128 <P>Hello,</P><P>I have the alphanumeric column "User_ID" in my table.In this column there are User IDs with 6 characters and User IDs with 8 characters.I would like to display all entries whose User_ID has 8 characters.Can someone please explain how I can filter that?</P><P>Many Thanks.</P><P>&nbsp;</P> Tue, 20 Oct 2020 10:12:09 GMT https://communities.sas.com/t5/SAS-Programming/Filter-by-number-of-characters/m-p/692803#M211128 Katrin1606 2020-10-20T10:12:09Z Re: Filter by number of characters https://communities.sas.com/t5/SAS-Programming/Filter-by-number-of-characters/m-p/692806#M211130 <PRE><CODE class=" language-sas">data want; set have; where length(user_id) = 8; run;</CODE></PRE> Tue, 20 Oct 2020 10:34:26 GMT https://communities.sas.com/t5/SAS-Programming/Filter-by-number-of-characters/m-p/692806#M211130 Kurt_Bremser 2020-10-20T10:34:26Z