topic Re: Filter on N digits in SAS Programming

Filter on N digits

NickK — Fri, 26 Mar 2021 14:24:37 GMT

Hello,

I have a numeric variable that is 6 numbers in length. I'd like to use SQL to only keep the numbers that are 3 digits long. So, for example, I would keep 123 but not 1234 or 12345 or 123456.

Thanks.

Re: Filter on N digits

PaigeMiller — Fri, 26 Mar 2021 14:31:37 GMT

In SQL, have it filter for any value between 100 and 999.

Re: Filter on N digits

NickK — Fri, 26 Mar 2021 14:40:45 GMT

So now the question is if the variable is character, how do I filter on that?

Re: Filter on N digits

ballardw — Fri, 26 Mar 2021 14:52:36 GMT

@NickK wrote:

So now the question is if the variable is character, how do I filter on that?

where length(variablename) =3

unless you have leading spaces in your character variable, then you need to STRIP the variable to remove leading spaces if you do not want to count them.

Re: Filter on N digits

PaigeMiller — Fri, 26 Mar 2021 15:53:42 GMT

Do you consider a character string of 003 to be 3 digits or 1 digit?

Re: Filter on N digits

NickK — Fri, 26 Mar 2021 16:25:46 GMT

There's no leading 0s or blanks in this case.