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);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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: