topic Re: Find String in advanced experssion in SAS Enterprise Guide

Find String in advanced experssion

xiaoyao026 — Wed, 29 Nov 2017 03:28:56 GMT

hello everyone

i'm trying to use advance expression to achieve below 2 function, to get a value as 1 or 0, however, difficult to find a proper function to acheive this.

1st function:

A: MOTOR

B: WIPER MOTOR,RHD

how can i judge if string of A include in B, if yes, then return 1, else 0

2nd function:

A: 34

B: 34;53;54

how can i judge if value A can be found in B, if yes, then return 1, else 0

thank you for advice in advance.

Re: Find String in advanced experssion

Reeza — Wed, 29 Nov 2017 04:26:22 GMT

INDEXW and FINDW will work in both your cases.

Re: Find String in advanced experssion

ballardw — Thu, 30 Nov 2017 23:01:05 GMT

Your exampled may require more details for instance is

A: MOTOR considered found

when

B: MOTORBOAT,RHD (part of word)

B: WIPER motor,RHD (case sensitive search)

or is

A: 34 considered found

when

B: 345;53;54