topic Word function Index() in SAS Programming

Word function Index()

hhchenfx — Thu, 01 Jun 2017 22:30:40 GMT

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

kiranv_ — Thu, 01 Jun 2017 22:29:26 GMT

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 — Thu, 01 Jun 2017 22:32:08 GMT

OMG, great thanks to you.
HC