topic Re: Data Manipulation in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Data-Manipulation/m-p/153386#M2657 <HTML><HEAD></HEAD><BODY><P>if company_name = 'ABC Company "Software"' and tradestyle = 'Software' then company_name = 'ABC Company';</P><P>More generic:</P><P>if substr(company_name,length(company_name)-length(tradestyle)-1) = '"'!!trim(tradestyle)!!'"' then</P><P>company_name = substr(company_name,1,length(company_name)-length(tradestyle)-3);</P><P></P><P>Please avoid to post the same question to multiple communities in the future.</P></BODY></HTML> Wed, 17 Dec 2014 10:57:17 GMT Kurt_Bremser 2014-12-17T10:57:17Z Data Manipulation https://communities.sas.com/t5/SAS-Data-Management/Data-Manipulation/m-p/153385#M2656 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 17 Dec 2014 10:18:15 GMT https://communities.sas.com/t5/SAS-Data-Management/Data-Manipulation/m-p/153385#M2656 gandikk 2014-12-17T10:18:15Z Re: Data Manipulation https://communities.sas.com/t5/SAS-Data-Management/Data-Manipulation/m-p/153386#M2657 <HTML><HEAD></HEAD><BODY><P>if company_name = 'ABC Company "Software"' and tradestyle = 'Software' then company_name = 'ABC Company';</P><P>More generic:</P><P>if substr(company_name,length(company_name)-length(tradestyle)-1) = '"'!!trim(tradestyle)!!'"' then</P><P>company_name = substr(company_name,1,length(company_name)-length(tradestyle)-3);</P><P></P><P>Please avoid to post the same question to multiple communities in the future.</P></BODY></HTML> Wed, 17 Dec 2014 10:57:17 GMT https://communities.sas.com/t5/SAS-Data-Management/Data-Manipulation/m-p/153386#M2657 Kurt_Bremser 2014-12-17T10:57:17Z