topic Re: Find and Remove Multiple String in SAS Data Management

Find and Remove Multiple String

pooiwan — Thu, 07 Sep 2017 08:11:02 GMT

Hi,

I have a variable as 'pr_ins_name' and example :

FASHION CO (M) BHD AS OWNER, LOOP
FASHION CO (M) BHD AS OWNER, LOOP INTER
ABC TECHONLOGY SDN BHD AS PRINCIPAL
ABD TECHONLOGY SDN BHD AS PRINCIPAL (AS MENTION
FLORA LIMITED

FLORA LTD
XYZ123 SDN BHD ON THE LIFE OF LKC
XYZ123 SDN BHD ON THE LIFE OF M
CAPTAIN APPAREL AS HIRER AND CONTRACTOR
YS ENTERPRISE AS HIRER AND HP DEVELOPMENT

I would like to remove those words (in Bold) :

1) contain "AS OWNER" , "AS PRINCIPAL" , "AS HIRER" , "ON THE LIFE OF" , "AS HIRER"

2) replace the "LIMITED" with "LTD"

How to combine above into one statement ?

data want;
set sasuser.name;

ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' AS OWNER')) ;
ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' AS HIRER')) ;
ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' AS PRINCIPAL')) ;
ins_name = substr (pr_ins_Name,1,find(pr_ins_name, ' ON THE LIFE OF')) ;

run;

Thank you.

Re: Find and Remove Multiple String

RW9 — Thu, 07 Sep 2017 08:55:00 GMT

Something like:

data want;
  set sasuser.name;
  do i="AS_OWNER","AS PRINCIPAL"...;
    ins_name=tranwrd(ins_name,i,"");
  end;
run;

You could also put your strings in a dataset and use that.

Re: Find and Remove Multiple String

pooiwan — Thu, 07 Sep 2017 10:58:38 GMT

I am trying below statement:

data want;
set sasuser.name;
do i=' AS OWNER',' AS PRINCIPAL','ON THE LIFE OF',' AS HIRER';
ins_Name = substr (pr_ins_Name,1,find(pr_ins_name, i)) ;
end;
run;

Only observation contains 'AS HIRER' has executed.

Message shown :

NOTE: Invalid third argument to function SUBSTR at line 31 column 12.

Output :

FASHION CO (M) BHD AS OWNER, LOOP
FASHION CO (M) BHD AS OWNER, LOOP INTER
ABC TECHONLOGY SDN BHD AS PRINCIPAL
ABD TECHONLOGY SDN BHD AS PRINCIPAL (AS MENTION
FLORA LIMITED
FLORA LTD
XYZ123 SDN BHD ON THE LIFE OF LKC
XYZ123 SDN BHD ON THE LIFE OF M
CAPTAIN APPAREL
YS ENTERPRISE

Thank you.

Re: Find and Remove Multiple String

Patrick — Thu, 07 Sep 2017 11:13:19 GMT

@pooiwan

Your approach as such seems more or less to work.

data sample;
  infile datalines truncover;
  input pr_ins_name $100.;
  pr_ins_name_orig=pr_ins_name;
  do search_str=' AS OWNER',' AS PRINCIPAL','ON THE LIFE OF',' AS HIRER';
    pr_ins_name = substr (pr_ins_name,1,find(pr_ins_name,search_str,'i'));
  end;

  datalines;
FASHION CO (M) BHD AS OWNER, LOOP
FASHION CO (M) BHD AS OWNER, LOOP INTER
ABC TECHONLOGY SDN BHD AS PRINCIPAL
ABD TECHONLOGY SDN BHD AS PRINCIPAL (AS MENTION
FLORA LIMITED
FLORA LTD
XYZ123 SDN BHD ON THE LIFE OF LKC
XYZ123 SDN BHD ON THE LIFE OF M
CAPTAIN APPAREL AS HIRER AND CONTRACTOR
YS ENTERPRISE AS HIRER AND HP DEVELOPMENT
;
run;

Re: Find and Remove Multiple String

RW9 — Thu, 07 Sep 2017 12:01:16 GMT

You do however notice that your code is different to mine yes?

    ins_name=tranwrd(ins_name,i,"");

And yours:

ins_Name = substr (pr_ins_Name,1,find(pr_ins_name, i)) ;

Mine removes strings, yours does a substring.

Re: Find and Remove Multiple String

pooiwan — Fri, 08 Sep 2017 01:40:55 GMT

Thank you for your assistant. The program is worked and solved my problem. Have a nice day.

Re: Find and Remove Multiple String

RW9 — Fri, 08 Sep 2017 09:31:27 GMT

In future please mark the post which answered the question as the correct answer, not your thank you post. Otherwise the answer post (which appears under the question) does not actually answer the question.

Re: Find and Remove Multiple String

Patrick — Fri, 08 Sep 2017 23:10:58 GMT

@pooiwan

Then mark the answer which you've used as the solution and not your answer to it.