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! ... View more

Hello, I am hoping that someone out there has already solved this and can share some handy code. I have two separate datasets that contain client information listing Name, Address, City, State and Zip code.  data1 is supplied by an external vendor while data2 is our internal records so they are not entered exactly the same way.  I need some ideas on best way to use SAS to process both files and find matches for same customer between the two files even if the name or address information is not entered as identical between the 2 files.  I use base SAS v9.4 in Windows environment. Thanks, in advance, for any insight! ... View more