https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843044#M36550 <P>Try</P> <PRE><CODE class=" language-sas">where string ^=: '8187' ;</CODE></PRE> <P>You can see more about the&nbsp; &nbsp;<STRONG>=:</STRONG> operator at&nbsp;<A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrcon/p00iah2thp63bmn1lt20esag14lh.htm" target="_self">SAS Operators in Expressions</A></P> <P>&nbsp;</P> <P>Go to the <EM><STRONG>Character Comparisons</STRONG></EM> link.</P> Tue, 08 Nov 2022 07:01:16 GMT mkeintz 2022-11-08T07:01:16Z https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843040#M36548 <P>How to filter out the number below start with "8187"? The format is string&nbsp;$CHAR8. Thanks</P><P>&nbsp;</P><P>Example:</P><P>81861234</P><P><STRONG>81876789</STRONG></P><P>81886577</P> Tue, 08 Nov 2022 06:35:20 GMT https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843040#M36548 P_Y 2022-11-08T06:35:20Z https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843041#M36549 <PRE><CODE class=" language-sas">where substr(number,1,4) = '8187';</CODE></PRE> <P>?</P> Tue, 08 Nov 2022 06:38:35 GMT https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843041#M36549 Kurt_Bremser 2022-11-08T06:38:35Z https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843044#M36550 <P>Try</P> <PRE><CODE class=" language-sas">where string ^=: '8187' ;</CODE></PRE> <P>You can see more about the&nbsp; &nbsp;<STRONG>=:</STRONG> operator at&nbsp;<A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrcon/p00iah2thp63bmn1lt20esag14lh.htm" target="_self">SAS Operators in Expressions</A></P> <P>&nbsp;</P> <P>Go to the <EM><STRONG>Character Comparisons</STRONG></EM> link.</P> Tue, 08 Nov 2022 07:01:16 GMT https://communities.sas.com/t5/New-SAS-User/Does-Not-Start-With/m-p/843044#M36550 mkeintz 2022-11-08T07:01:16Z