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
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 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: