Data Manipulation

[gandikk]

There are 2 fields called Company Name and Tradestyle. My requirement is if company name is ABC Company "Software" and the tradestyle is Software; I have to change the company name to ABC Company. That means I have to remove the string in double quotes from the Company Name if it is matched to Tradestyle. Can anyone help on this?

[Ksharp]

Post your some sample data.

[RW9]

Its a duplicate question: https://communities.sas.com/message/242511#242511