help on function like 'find'

tulip — Wed, 14 Apr 2010 03:13:24 GMT

Hi, pros:

Here is the statement as follows:

where find(concept, 'Condition1','i')>0 or find(concept, 'Condition2','i')>0

however, I would like to like conditions to be listed in the following way conceptually so that it is easier to manage plus achieving the find function.

where id in ('A', 'B', 'C');

Your help is appreciated so much. Tulip.

Re: help on function like 'find'

Doc_Duke — Wed, 14 Apr 2010 05:54:46 GMT

To use the simple syntax of the IN operator means that you have to pre-process your data to pull the conditions of interest out of the concept variable. It is really a case of 'pay me now or pay me later', at some point you have to parse the variable concept.

TANSTAAFL

topic help on function like 'find' in SAS Procedures

help on function like 'find'

Re: help on function like 'find'