Filter by number of characters

[Katrin1606]

Hello,

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?

Many Thanks.

[Kurt_Bremser]

data want;
set have;
where length(user_id) = 8;
run;