Index() function pick up unnecessary records

[hhchenfx]

Hi Everyone,

I have a quick question. When I run the 

if index(project,"VI SP - OH")>0 then output;

SAS pick up also record such as "014 VI SP" which clearly have no "- OH" component.

Can you fix my code so it strictly pick only those containing "VI SP - OH" ?

Thank you,

HHC

[WarrenKuhfeld · Accepted solution]

The INDEX function works correctly.  Double check your data and the rest of the logic in your program.  Are you outputting other records by using another OUTPUT statement?

[Tom]

Something else is your issue.

The INDEX function will not match strings that are not exactly the same.

574   data test;
575    input project $70. ;
576    found=index(project,"VI SP - OH");
577    put found= project=$quote. ;
578   cards;

found=0 project="014 VI SP which clearly have no ""- OH"" component."
found=5 project="015 VI SP - OH"
NOTE: The data set WORK.TEST has 2 observations and 2 variables.

[hhchenfx]

My bad. I am sorry.

HHC