IndexC Function arguments

[athapa1183]

HI 

I want to Know the position of first occurence of '~LX' or '~HL' or '~SE' whichever comes first.

I don't now why the code is not WorKing.

I will really appreciate your help.

data s1;
input string :$2000.;
Datalines;
SV1*HC+99348+LM*25+KX++++CARE*84*UN*1*12**1~DTP*472*RD8*20180720-20180720~LX*1~
SV1*HC+11721+59+~HL*1~*Q8+XX++CARE*47*UN*1*~LX*1~*12**2+3~DTP*472*RD8*20180720-20180720~REF*6R*2~
SV1*HC+11057+Q8+JX++~HL*+LX+CARE*70*UN*1*12**4+1~DTP*472*RD8*~LX*4~20180720-20180720~REF
SV1*HC+~SE+99213+LX+~SE+++CARE*150*UN*1*11**1+2~DTP*472*RD8*~LX*2~*20181004-20181004~REF*
;

data s2;
set s1;
word1= indexc(String,'~LX', '~HL','SE') ;
run;

[RW9]

Read the manual:

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1s...

Particularly:

Details

The INDEXC function searches source, from left to right, for the first occurrence of any character present in the excerpts and returns the position in source of that character. If none of the characters in excerpt-1 through excerpt-n in source are found, INDEXC returns a value of 0.

So indexc will return the position of the first character from your list, not the whole string.  

Use index for this:

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n0vxokxhv8l...

[Shmuel · Accepted solution]

INDEXC is used to get the position of a character in a string.

You may enter a list of characters to search for if any is found the position of first of them will be in result.

As same line may have any searched string more than once you must check each separately.

That can be done either by INDEX() or by FIND() functions.

For example:

data want;
 set have;
       pos1 = index(string,'~LX');
       pos2 = index(string,'~HL');
       pos3 = index(string,'SE');
       .....
       word = min(pos1-pos3);
run;

If you are looking for first '~' character you can use INDEX / INDEXC / FIND functions;

       word = indexc(string,'~');

[athapa1183]

I really appreciate your help.