topic Re: Contains? in SAS Procedures

Contains?

bollibompa — Mon, 20 Apr 2015 07:17:53 GMT

Hi,

Hope anyone can help with this problem:

I hava two colums (character), a and b like this:

a	b
0\|1\|2\|3\|4	0\|1\|2\|3\|4\|5\|6\|7\|8
3\|4	0\|1\|2\|3\|4\|5\|6\|7\|8
0\|1\|2\|3\|4	1\|2\|3\|4\|5\|6\|7\|8
0\|1\|2\|3\|4	0\|1\|2\|3

I want to add a third variable (match) if column b contains the information in column a. Like this

a	b	match
0\|1\|2\|3\|4	0\|1\|2\|3\|4\|5\|6\|7\|8	1
3\|4	0\|1\|2\|3\|4\|5\|6\|7\|8	1
0\|1\|2\|3\|4	1\|2\|3\|4\|5\|6\|7\|8	0
2\|3\|4	0\|1\|2\|3	0

Can this be done with contains-function?

Thanks

Thomas

Re: Contains?

grimol — Mon, 20 Apr 2015 07:33:43 GMT

if index(strip(b),strip(a))>0 then match=1;

else match=0;

Re: Contains?

RW9 — Mon, 20 Apr 2015 08:04:29 GMT

Hi,

Several ways really:

data want;

set have;

if index(a,b)>0 then match=1;

else match=0;

run;

You could also use Perl Regular Expressions. Or the find() function. Etc.

Re: Contains?

grimol — Mon, 20 Apr 2015 08:08:36 GMT

A Forum where you can see the postings not until 6 hours after posting is..... useless.....

Re: Contains?

Jagadishkatam — Mon, 20 Apr 2015 08:34:06 GMT

Hi ,

I tried the same but i am not sure why using index function, it is not working

However with find function with trim modifier it is working

data have;

input a :$10. b :$20.;

datalines;

0|1|2|3|4 0|1|2|3|4|5|6|7|8

3|4 0|1|2|3|4|5|6|7|8

0|1|2|3|4 1|2|3|4|5|6|7|8

run;

data want;

set have;

if find(b,a,"t")>0 then match=1;

else match=0;

run;

Thanks,

Jag

Re: Contains?

bollibompa — Mon, 20 Apr 2015 08:38:25 GMT

Thanks,

However, I cound not make thiscode work. Every match is 0

Re: Contains?

bollibompa — Mon, 20 Apr 2015 08:39:52 GMT

The find function is working. Thanks

Re: Contains?

RW9 — Mon, 20 Apr 2015 08:52:23 GMT

Had it the wrong way round:

data want;

set have;

if index(b,a)>0 then match=1;

else match=0;

run;

Re: Contains?

bollibompa — Mon, 20 Apr 2015 09:42:02 GMT

Thanks

Re: Contains?

Jagadishkatam — Mon, 20 Apr 2015 13:11:44 GMT

Hi,

Even the following code does not work, in the beginning i tried the same but i wonder why the index is not working in this case.Any thoughts

data want;

set have;

if index(b,a)>0 then match=1;

else match=0;

run;

Re: Contains?

grimol — Mon, 20 Apr 2015 13:14:03 GMT

tried with "strip()"?

Re: Contains?

RW9 — Mon, 20 Apr 2015 13:42:48 GMT

Blanks, that's the problem. Using a variable means all the characters including suffix blanks are used:

data have;

a="0|1|2|3|4"; b="0|1|2|3|4|5|6|7|8"; output;

a="3|4"; b="0|1|2|3|4|5|6|7|8"; output;

run;

data want;

set have;

tmp=index(b,strip(a));

run;

In the previous one, a refers to 3|4_____ with the underscores as blanks, so it isn't found.

Re: Contains?

Jagadishkatam — Mon, 20 Apr 2015 13:47:10 GMT

Thank you, that solves the problem

Re: Contains?

Reeza — Mon, 20 Apr 2015 14:21:44 GMT

Only because you're a new user, it's a spam control issue at the moment I believe.