topic Re: how to serach for a text and assign a value in SAS Programming

how to serach for a text and assign a value

tekish — Tue, 24 Jan 2017 15:46:54 GMT

I have a an excel which contains extra character. How to serach for a specific strung and create another column to assign those value.

Here is a sample example.

data check;

input Message$40. ID ;

cards;

this&is&the&season 2

chrome&is&powerful&chrome 4

chrome&is&causing&the&Error&chrome. 3

the&service&center&is&causing&the&Error. 5

the&error&is&comming&from&IE9 6

the &error&is&comming&from&chrome 7

chrome&is&causing&the&Error&IE9 . 9

the&service&center&is&causing&the&Error. 10

the&error&is&comming&from&IE9 11

the&error&is&comming&from&chrome 12

;

run;

data check2;

set check;

if Message="chrome" then flag="chorme";

if Message="IE9" then flag="IE9";

else flag="";

run;

Re: how to serach for a text and assign a value

anoopmohandas7 — Tue, 24 Jan 2017 15:55:28 GMT

try using a CASE statement with LIKE in case you wanted to match any value within a string. Hope the below example sheds some light.

data check;
input Message$40. ID ;
cards;
this&is&the&season                                               2
chrome&is&powerful&chrome                               4
chrome&is&causing&the&Error&chrome.             3
the&service&center&is&causing&the&Error.        5
the&error&is&comming&from&IE9                        6
the &error&is&comming&from&chrome                7
chrome&is&causing&the&Error&IE9 .                  9
the&service&center&is&causing&the&Error.      10
the&error&is&comming&from&IE9                      11
the&error&is&comming&from&chrome               12
;
run;

proc sql ;
select 
case  
when Message like "%chrome%" then "chorme"
when Message like "%IE9%" then "IE9"
else "None" 
end as flag,ID
from check;
quit ;

Re: how to serach for a text and assign a value

ballardw — Tue, 24 Jan 2017 16:00:11 GMT

I think you may be looking for this:

if indexw(upcase(Message),"CHROME",'&')>0 then flag="chrome";

Since this looks like unstructured text the upcase and the searched for word in upper case may work better if you want to find Chrome, CHROME, CHrome, cHrome and such. I recommend a similar UPCASE approach with the IE9 search as you may have folks enter ie9.

Re: how to serach for a text and assign a value

mkeintz — Tue, 24 Jan 2017 16:02:15 GMT

Waht do you want to do if both chrome and IE9 are present?