topic Re: Choosing output based on certain Text String in SAS Procedures

Choosing output based on certain Text String

jacob_klimek — Fri, 27 May 2016 19:07:51 GMT

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.

Re: Choosing output based on certain Text String

Reeza — Fri, 27 May 2016 19:49:43 GMT

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));

Re: Choosing output based on certain Text String

Astounding — Fri, 27 May 2016 21:28:06 GMT

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);