topic SAS Base Question in New SAS User

SAS Base Question

Pandu — Mon, 17 Dec 2018 10:09:36 GMT

I have a data set with variable name called description.

Description="The mobile is produced by Apple"

From the above string, i want to extract from by Apple

the length is not consistence but i wanted to extract from by.

Thanks in advance.

Re: SAS Base Question

Jagadishkatam — Mon, 17 Dec 2018 10:18:07 GMT

data want;
input description&$100.;
new=substr(description,index(description,'by'));
cards;
The mobile is produced by Apple
;

Re: SAS Base Question

Jagadishkatam — Mon, 17 Dec 2018 10:25:21 GMT

alternatively by perl regular expressions

data want;
input description&$100.;
new=prxchange('s/(.*)(by*)/$2/i',-1,strip(description));
cards;
The mobile is produced by Apple
;

Re: SAS Base Question

Pandu — Mon, 17 Dec 2018 10:35:01 GMT

Hi Jag...I dont want to use by...

after certain string i want to dived into two strings.

Re: SAS Base Question

RW9 — Mon, 17 Dec 2018 10:37:52 GMT

I would recommend using the findw() function rather than index, which will find any occurrences of the word "by" in the string rather than any occurrences (e.g. it index would find it in "byway").

data want;
  input description $100.;
  new=substr(description,findw(description,'by'));
cards;
The mobile is produced by Apple
;
run;

Re: SAS Base Question

RW9 — Mon, 17 Dec 2018 10:39:17 GMT

Provide test data in the form of a datastep:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Then show what you want out at the end from that test data. Also explain fully what your problem is and logic. Your original post only stipulated split by "by", we cannot guess any further what your intentions are!

Re: SAS Base Question

ballardw — Mon, 17 Dec 2018 19:52:23 GMT

@Pandu wrote:

Hi Jag...I dont want to use by...

after certain string i want to dived into two strings.

Show explicit desired output.

This description of "...I dont want to use by" is not quite consistent with your original question.

Also It might help to show more than one worked example if you need to use something other than "by" as the split element.