topic Re: removing phrases from a string in SAS Procedures

removing phrases from a string

SASbeginner20 — Tue, 14 Jul 2015 19:18:40 GMT

What procedure would I use to remove multiple phrases within a string?

I want to remove the "LLC", "Inc", and "Incorporated"

Is there a way to remove this all in one line/step of code rather than multiple steps?

Name

Company 1 LLC

Company 2 Incorporated

Company 3 Inc.

Thanks so much.

Re: removing phrases from a string

dcruik — Tue, 14 Jul 2015 20:28:55 GMT

You could use the tranwrd() function multiple times on the Name field to replace a substring with a different substring, in this instance a blank. I would assume you don't want the space after 1 in Company 1 LLC, so I would try the following:

data want;

set have;

Name=tranwrd(Name," LLC","");

Name=tranwrd(Name," Incorporated","");

Name=tranwrd(Name," Inc.","");

run;

Hope this helps!

Re: removing phrases from a string

Patrick — Tue, 14 Jul 2015 21:41:01 GMT

A RegEx option which will only remove the targeted strings if they are at the very end.

data have;

infile datalines truncover;

input company_name $40.;

datalines;

Company 1 LLC

Company 2 Incorporated

Company LLC 3 Inc.

Lend Lease Group LLC Inc.

;

run;

data want;

set have;

length company_name_root $40;

company_name_root=prxchange('s/(LLC|Incorporated|Inc\.)\s*$//oi',1,company_name);

run;

Re: removing phrases from a string

stat_sas — Tue, 14 Jul 2015 23:36:49 GMT

data want(drop=list);

set have;

length list $30;

do list = 'LLC', 'Incorporated', 'Inc.';

Name = tranwrd(strip(Name),strip(list),'');

end;

run;