topic Trying to remove a dash and all numbers after it in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85651#M24499 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I'm a new user to SAS so this may sound like an easy question but I can't figure it out. I have a list of numbers that have a dash at the end of the number followed by additional numbers. The numbers before the dash can range in length from 8-12 digits long. I'm trying to remove the dash and all the numbers that follow the dash. Below is an example</P><P>12345-1&nbsp; would like it to read as 12345</P><P>123456789-00 would like it to read as 123456789</P><P>123456789123-002 would like it to read as 123456789123</P><P></P><P>Hopefully that makes sense. Any help would be greatly appreciated.</P></BODY></HTML> Fri, 24 May 2013 16:37:16 GMT brywhi11 2013-05-24T16:37:16Z Trying to remove a dash and all numbers after it https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85651#M24499 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I'm a new user to SAS so this may sound like an easy question but I can't figure it out. I have a list of numbers that have a dash at the end of the number followed by additional numbers. The numbers before the dash can range in length from 8-12 digits long. I'm trying to remove the dash and all the numbers that follow the dash. Below is an example</P><P>12345-1&nbsp; would like it to read as 12345</P><P>123456789-00 would like it to read as 123456789</P><P>123456789123-002 would like it to read as 123456789123</P><P></P><P>Hopefully that makes sense. Any help would be greatly appreciated.</P></BODY></HTML> Fri, 24 May 2013 16:37:16 GMT https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85651#M24499 brywhi11 2013-05-24T16:37:16Z Re: Trying to remove a dash and all numbers after it https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85652#M24500 <HTML><HEAD></HEAD><BODY><P>new_number=scan(number, 1, "-");</P></BODY></HTML> Fri, 24 May 2013 16:38:35 GMT https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85652#M24500 Reeza 2013-05-24T16:38:35Z Re: Trying to remove a dash and all numbers after it https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85653#M24501 <HTML><HEAD></HEAD><BODY><P>That worked! Thank you very much! </P></BODY></HTML> Fri, 24 May 2013 16:45:07 GMT https://communities.sas.com/t5/SAS-Procedures/Trying-to-remove-a-dash-and-all-numbers-after-it/m-p/85653#M24501 brywhi11 2013-05-24T16:45:07Z