topic Re: Deleting particular strings from variable's names in SAS Programming

Deleting particular strings from variable's names

Saba1 — Sun, 30 Sep 2018 05:45:44 GMT

I have a dataset with a variable of "Comp_Name", it consists of the long names of various companies. I want to delete the observations where "company_name" includes specific strings e.g. ‘IDX’, ‘S&P’, ‘DOW JONES’ and ‘MSCI’.

Please see the sample below:

Data have;
input ID Comp_Name $;
datalines;
 105246 AARI Growth S&P: Social Principl Inst.
 105246 AARI Growth S&P: Social Principl Inst.
 105290 Atlas Assets Inc. Health Servc
 105290 Atlas Assets Inc. Health Servc
 105290 Atlas Assets Inc. Health Servc
 116020 AARE Income: Invst IDX
 147001 Evergreen Select: Dow Jones: Diversified Value
 147001 Evergreen Select: Dow Jones: Diversified Value
; run;

I want the following:

Data want;
input ID Comp_Name $;
datalines;
 105290 Atlas Assets Inc. Health Servc
 105290 Atlas Assets Inc. Health Servc
 105290 Atlas Assets Inc. Health Servc
; run;

Need your guidance. Thanks

Re: Deleting particular strings from variable's names

PeterClemmensen — Sun, 30 Sep 2018 06:04:09 GMT

Do like this

Data have;
input ID $ Comp_Name $50.;
infile datalines missover;
datalines;
105246 AARI Growth S&P: Social Principl Inst.
105246 AARI Growth S&P: Social Principl Inst.
105290 Atlas Assets Inc. Health Servc
105290 Atlas Assets Inc. Health Servc
105290 Atlas Assets Inc. Health Servc
116020 AARE Income: Invst IDX
147001 Evergreen Select: Dow Jones: Diversified Value
147001 Evergreen Select: Dow Jones: Diversified Value
;

data want;
   set have;
   where prxmatch("m/idx|dow jones|msci|s&p/oi",Comp_Name)=0;
run;

Re: Deleting particular strings from variable's names

Ksharp — Sun, 30 Sep 2018 12:07:30 GMT

Better add \b for matching a word ,not a string.

Data have;
input ID $ Comp_Name $50.;
infile datalines missover;
datalines;
105246 AARI Growth S&P: Social Principl Inst.
105246 AARI Growth S&P: Social Principl Inst.
105290 Atlas Assets Inc. Health Servc
105290 Atlas Assets Inc. Health Servc
105290 Atlas Assets Inc. Health Servc
116020 AARE Income: Invst IDX
147001 Evergreen Select: Dow Jones: Diversified Value
147001 Evergreen Select: Dow Jones: Diversified Value
;

data want;
   set have;
   if prxmatch('/\b(idx|dow jones|msci|s&p)\b/oi',Comp_Name) then delete;
run;

proc print;run;

Re: Deleting particular strings from variable's names

Saba1 — Mon, 01 Oct 2018 02:34:01 GMT

Thanks. It is so helpful.

Re: Deleting particular strings from variable's names

Saba1 — Mon, 01 Oct 2018 02:34:13 GMT

Thanks a lot.