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
M
want=strip(tranwrd(have,"Borough of",""));
want=strip(tranwrd(have,"Borough of",""));
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.
M
Hi,
Here in this case you can even try
want=scan(city,-1);
Thanks
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 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.