Help using Base SAS procedures

Trying to remove a dash and all numbers after it

Reply
Occasional Contributor
Posts: 5

Trying to remove a dash and all numbers after it

Hello

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

12345-1  would like it to read as 12345

123456789-00 would like it to read as 123456789

123456789123-002 would like it to read as 123456789123

Hopefully that makes sense. Any help would be greatly appreciated.

Super User
Posts: 19,810

Re: Trying to remove a dash and all numbers after it

new_number=scan(number, 1, "-");

Occasional Contributor
Posts: 5

Re: Trying to remove a dash and all numbers after it

That worked! Thank you very much!

Ask a Question
Discussion stats
  • 2 replies
  • 439 views
  • 0 likes
  • 2 in conversation