BookmarkSubscribeRSS Feed
brywhi11
Calcite | Level 5

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.

2 REPLIES 2
Reeza
Super User

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

brywhi11
Calcite | Level 5

That worked! Thank you very much!

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2440 views
  • 0 likes
  • 2 in conversation