06-01-2017 06:26 PM - edited 06-01-2017 06:30 PM
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?
Need further help from the community? Please ask a new question.