https://communities.sas.com/t5/SAS-Enterprise-Guide/Strip-characters-from-a-value-in-a-column/m-p/1517#M471 Hi. I am new to SAS (I havent had training yet - but did take the tutorial) and I am looking for a way to format data that I am using in EG. I have a column in my data that is based on customer names. Some names have additional info on the end that I need to remove. IE<BR /> 1. JOHN DOE<BR /> 2. JOHN DOE@SAS.COM<BR /> If I wanted to strip the @SAS.com or everything after the @ , How would I do that?<BR /> In the example above I would want John Doe counted twice not 2 different entries.<BR /> Thanks. Fri, 06 Oct 2006 14:35:27 GMT deleted_user 2006-10-06T14:35:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Strip-characters-from-a-value-in-a-column/m-p/1517#M471 Hi. I am new to SAS (I havent had training yet - but did take the tutorial) and I am looking for a way to format data that I am using in EG. I have a column in my data that is based on customer names. Some names have additional info on the end that I need to remove. IE<BR /> 1. JOHN DOE<BR /> 2. JOHN DOE@SAS.COM<BR /> If I wanted to strip the @SAS.com or everything after the @ , How would I do that?<BR /> In the example above I would want John Doe counted twice not 2 different entries.<BR /> Thanks. Fri, 06 Oct 2006 14:35:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Strip-characters-from-a-value-in-a-column/m-p/1517#M471 deleted_user 2006-10-06T14:35:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Strip-characters-from-a-value-in-a-column/m-p/1518#M472 You can use the following function:<BR /> <BR /> var2 = scan ( var1 , 1 , '@' ); Fri, 06 Oct 2006 14:49:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Strip-characters-from-a-value-in-a-column/m-p/1518#M472 deleted_user 2006-10-06T14:49:19Z