https://communities.sas.com/t5/Streaming-Analytics/Extract-data-before-a-specific-character/m-p/704148#M226 <P>The SCAN() function will do that.</P> <PRE><CODE class=" language-sas">Number_New = scan(number,1,'-');</CODE></PRE> Mon, 07 Dec 2020 14:41:21 GMT Tom 2020-12-07T14:41:21Z https://communities.sas.com/t5/Streaming-Analytics/Extract-data-before-a-specific-character/m-p/704147#M225 <P>Hi all!</P><P>I have a data set with a bunch of&nbsp;Numbers and then an user number&nbsp;like eg.below. I want to delete all the characters from "-" and include only the numbers before "-" for each number. Any help with SAS code is much appreciated.</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P><P>Number</P><P>4050123456-1</P><P>4098765478-1</P><P>4901898089898999-1</P><P>&nbsp;</P><P>Want:</P><P>Number_New</P><P>4050123456</P><P>4098765478</P><P>4901898089898999</P> Mon, 07 Dec 2020 14:37:16 GMT https://communities.sas.com/t5/Streaming-Analytics/Extract-data-before-a-specific-character/m-p/704147#M225 Talita28 2020-12-07T14:37:16Z https://communities.sas.com/t5/Streaming-Analytics/Extract-data-before-a-specific-character/m-p/704148#M226 <P>The SCAN() function will do that.</P> <PRE><CODE class=" language-sas">Number_New = scan(number,1,'-');</CODE></PRE> Mon, 07 Dec 2020 14:41:21 GMT https://communities.sas.com/t5/Streaming-Analytics/Extract-data-before-a-specific-character/m-p/704148#M226 Tom 2020-12-07T14:41:21Z