Solved: Does Not Start With

P_Y · Posted 11-08-2022 01:35 AM

How to filter out the number below start with "8187"? The format is string $CHAR8. Thanks

Example:

81861234

81876789

81886577

Kurt_Bremser · Posted 11-08-2022 01:38 AM

where substr(number,1,4) = '8187';

?

Kurt_Bremser · Posted 11-08-2022 01:38 AM

where substr(number,1,4) = '8187';

?

mkeintz · Posted 11-08-2022 02:01 AM

Try

where  string   ^=: '8187' ;

You can see more about the =: operator at SAS Operators in Expressions

Go to the Character Comparisons link.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Does Not Start With