Hello,
I have a dataset with a bunch of addresses, unfortunately they are all combined into one line and I need to parse out everything that comes after the person's name into one line.
Data that I have:
id Name address_line city_state zipcode
1 John Doe john doe 123 Central Avenue New York, NY 12345
Data I want:
id Name address_line_1 city_state zipcode
1 John Doe 123 Central Avenue New York, NY 12345
I know I probably have to use index and substring or some combination of those, but I really have no idea where to start.
That looks like the right set of tools, but I think you are looking for this:
address_line_1 = substr(address_line, length(name) + 2);
Use the length of name as the second argument to substr function. It tells it where to start the substr and leaving out the third parameter tells it to take the rest of the string.
Address = substr(address_line1, length(name));
That looks like the right set of tools, but I think you are looking for this:
address_line_1 = substr(address_line, length(name) + 2);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: