topic Re: Extract specific word from character variables in SAS Programming

Extract specific word from character variables

petlove — Wed, 08 Aug 2018 17:01:31 GMT

Hi all,

I am looking for way to extract the specific word from character variables where specific word is present in other variable.

For example:

one dataset has var1 variable and other dataset has var2 variables:

1. var1: it has value "Missing variable: IESTRESC "

2. var2: it has value "IESTRESC"

Now, I want to remove all other text and just keep "IESTRESC" in var1 variable. how should it be done?

NOTE: position of "IESTRESC" can be anywhere in var1.

Thank you.

Re: Extract specific word from character variables

novinosrin — Wed, 08 Aug 2018 17:09:23 GMT

If you could present a nice comprehensive data sample of your dataset, that would help the community better

Meaning sample of both your datasets with values like 5 records each

Re: Extract specific word from character variables

PaigeMiller — Wed, 08 Aug 2018 17:11:15 GMT

UNTESTED CODE

data want;
    set have;
    if find(var1,'IESTRESC')>0 then var1='IESTRESC';
run;

Re: Extract specific word from character variables

ballardw — Wed, 08 Aug 2018 17:27:18 GMT

Only one value? Or a bunch of values that you need to examine each value for possible occurrence in the variable?

If you have more than one value to search for is it possible that two or more may occur in the long value? If so what would the result look like then?

Would that searched for value possibly occur as part of other words?

Is the search value going to be case sensitive?

And are there any spelling errors such that you have IESTRSC instead of IESTRESC that also need to match?

Re: Extract specific word from character variables

ChrisNZ — Thu, 09 Aug 2018 02:04:35 GMT

Like this?

data WANT;
  set HAVE;
  if find(VAR1,VAR2,'t') then VAR1=VAR2;
run;