topic Index() function pick up unnecessary records in SAS Programming

Index() function pick up unnecessary records

hhchenfx — Tue, 07 Nov 2017 16:23:10 GMT

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

Re: Index() function pick up unnecessary records

WarrenKuhfeld — Tue, 07 Nov 2017 16:26:32 GMT

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?

Re: Index() function pick up unnecessary records

Tom — Tue, 07 Nov 2017 16:32:14 GMT

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.

Re: Index() function pick up unnecessary records

hhchenfx — Tue, 07 Nov 2017 17:13:26 GMT

My bad. I am sorry.

HHC