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);
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.