topic How to remove part of a word? in SAS Programming

How to remove part of a word?

Malathi13 — Wed, 31 Jan 2018 13:56:59 GMT

Hi,

I have a data with a variable City and that includes Boroughs. I don't want to have Borough in the City and want to take of the Borough from the City. How can I do that? , I used compress but it is not working the way I want the output to be.

E.g.

City

Albany

Delmar

Troy

Borough of Bronx

Borough of Queens

Borough of Brooklyn

Manhattan

Buffalo

Suffolk

Nassau

I don't want "Borough of" and only want to display it as Bronx or Queens etc. I have around more than 100 observations with different City names. I can't use 100 if-then statements. Is there a easy way to do this.

Thank you

Re: How to remove part of a word?

RW9 — Wed, 31 Jan 2018 14:02:49 GMT

want=strip(tranwrd(have,"Borough of",""));

Re: How to remove part of a word?

Malathi13 — Wed, 31 Jan 2018 14:11:56 GMT

Hi RW9,

I just used tranwrd without strip and it worked perfectly as I wanted and you gave the same with strip. Thank you so much for the answer. This saved me a lot of time and writing a long code.

Re: How to remove part of a word?

srinath3111 — Wed, 31 Jan 2018 14:22:35 GMT

Hi,

Here in this case you can even try

want=scan(city,-1);

Thanks