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"?

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 1158 views
  • 8 likes
  • 3 in conversation