https://communities.sas.com/t5/SAS-Data-Management/Extracting-a-portion-of-data/m-p/228116#M5539 <P>company_name = scan(company_name, 1, "(" );</P> Thu, 01 Oct 2015 19:47:51 GMT Astounding 2015-10-01T19:47:51Z https://communities.sas.com/t5/SAS-Data-Management/Extracting-a-portion-of-data/m-p/228112#M5538 <P>I have a variable "company_name" as portion shown below:&nbsp; I need to extract everything that comes before the first open parenthesis "(" and create either a new variable or frankly just remove all information after the first open paren "(".&nbsp; Any tips?</P><P>&nbsp;</P><P>CUTWATER SELECT INCOME FUND (RIVUS BOND FUND PRIOR TO 12/2011)</P><P>US DRY CLEANING CORP (FIRST VIRTUAL COMMUNICATIONS INC PRIOR TO 12/2005)</P><P>NORDION INC (MDS INC PRIOR TO 11/2010)</P><P>&nbsp;</P><P>Need final variable to look like:</P><P>CUTWATER SELECT INCOME FUND</P><P>US DRY CLEANING CORP</P><P>NORDION INC</P><P>&nbsp;</P><P>Thank you!</P><P>Matthew</P> Thu, 01 Oct 2015 19:44:23 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-a-portion-of-data/m-p/228112#M5538 matthewF 2015-10-01T19:44:23Z https://communities.sas.com/t5/SAS-Data-Management/Extracting-a-portion-of-data/m-p/228116#M5539 <P>company_name = scan(company_name, 1, "(" );</P> Thu, 01 Oct 2015 19:47:51 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-a-portion-of-data/m-p/228116#M5539 Astounding 2015-10-01T19:47:51Z