BookmarkSubscribeRSS Feed
gwcanalytics
Calcite | Level 5

Does anyone out there have code to share that will help me to extract numbers out of a character variable that may or may not have numbers embedded in the observation?

Specifically, I just need to extract the street number out of a variable that contains the street address but no guarantee where the street number is embedded in the string or how many digits there are.

Thanks, in advance, for any help!

4 REPLIES 4
data_null__
Jade | Level 19

Start with ANYDIGIT function and work from there.

gwcanalytics
Calcite | Level 5

Thank you!  This was very helpful to get me started.

Reeza
Super User

compress with kd option is also useful.

data_null__
Jade | Level 19

What will COMPRESS KD give for "123 West 23rd"?

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 Update

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1918 views
  • 8 likes
  • 3 in conversation