topic Re: A character variable in another characteristic variable in SAS Programming

A character variable in another characteristic variable

cool1993 — Thu, 26 Sep 2019 12:43:59 GMT

Hello,

I want to determine whether one character variable(Char1) is included in another character variable(Char2).

The data and the desired results are as follows:

data

NAME	YEAR	Char1	Char2
JOY	2011	AA	AA, BB
JOY	2011	BB	AA, BB
JOY	2012	AA	AA, BB, CC
JOY	2012	BB	AA, BB, CC
JOY	2012	CC	AA, BB, CC
JOY	2013	CC	CC
JOY	2013	BB	CC

desired result

NAME	YEAR	Including
JOY	2011	1
JOY	2011	1
JOY	2012	1
JOY	2012	1
JOY	2012	1
JOY	2013	1
JOY	2013	0

If you know how, please help me.

Re: A character variable in another characteristic variable

s_lassen — Thu, 26 Sep 2019 12:53:54 GMT

The INDEXW function may be what you are looking for:

data want;
  set have;
  including=(indexw(char2,char1,', ')>0);
run;

Re: A character variable in another characteristic variable

PeterClemmensen — Thu, 26 Sep 2019 12:59:46 GMT

data have;
input NAME $ YEAR Char1 $ Char2 $ 13-22;
datalines;
JOY 2011 AA AA, BB
JOY 2011 BB AA, BB
JOY 2012 AA AA, BB, CC
JOY 2012 BB AA, BB, CC
JOY 2012 CC AA, BB, CC
JOY 2013 CC CC
JOY 2013 BB CC
;

data want;
    set have;
    Including=find(Char2, Char1, 't')>0;
run;