Word function Index()

[hhchenfx]

Hi,

I want to take all records with word "Income" in column Item . And the below code somehow fail! SAS return no record for data Want

	data Want; set Have;
	if Index(item,"Income")=1 ; run;

So I take a row full value ("42700 · Consulting Income") and try to see if SAS work with full value. And SAS correctly pick the row as code below:

	data check1; set PL;
	if Index(item,"42700 · Consulting Income")=1 ; run;

Can anyone help me to correct my original code?

Is that caused by the little dot in the string?

Thanks

HC

[kiranv_ · Accepted solution]

One means it sees  the only in starting position, so change it to greater than zero, it can find value anywhere

if Index(item,"Income")>0

[hhchenfx]

OMG, great thanks to you.
HC