topic Re: Filter out Numbers starting with '04' in SAS Enterprise Guide

Filter out Numbers starting with '04'

pcfriendly — Tue, 26 Nov 2013 04:28:52 GMT

Hi Forum,

I have a table of data that contains a Column of telephone numbers.

I want to filter out any records where the telephone number field has a number beginning with '04'.

So far I've added an Advanced Expression something like the below in SAS EG 4.3.

SUBSTR(TELEPHONE_NO, 1, 2) <> '04'

This doesn't work & changes all telephone nunmbers to a single digit, 0, 1 2 etc.

I'd prefer to add afilter in a Query Builder but there isn't an option to write the above expression...

Can anyone advise how this can be done?

Thanks

Patrick — Tue, 26 Nov 2013 05:33:11 GMT

Not sure about EG 4.3 but in newer versions in the Query Builder you could select as filter operator "Does not match pattern" and as value '04%'

This will translate into SQL: TELEPHONE_NO NOT LIKE '04%'

pcfriendly — Tue, 26 Nov 2013 20:39:37 GMT

Thanks Patrick !

I had tried that using just '04' but didn't think to include the %, DUH ...