DATA Step, Macro, Functions and more

Index function

Reply
Super Contributor
Posts: 647

Index function

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.
Trusted Advisor
Posts: 2,113

Re: Index function

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

will do that.
Super Contributor
Super Contributor
Posts: 3,174

Re: Index function

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

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 2 replies
  • 101 views
  • 0 likes
  • 3 in conversation