Index function - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

Index function

Posted 10-14-2009 10:06 AM (4104 views)

if index(name,'Novo Distribution')

Can we make the search not case sensitive?
Like if the argument-2 here 'Novo Distribution' can be in any case.

2 REPLIES 2

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: Index function

Posted 10-14-2009 10:49 AM (4100 views) | In reply to SASPhile

if index(upcase(name),upcase('Novo Distribution'))

will do that.

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: Index function

Posted 10-14-2009 06:05 PM (4100 views) | In reply to Doc_Duke

Also, consider the FIND function which is case-blind by default.

Scott Barry
SBBWorks, Inc.