08-19-2017 10:15 AM
Hi, In my "HAVE" dataset, if "var1" is not in the string "not_in", I'd like to tag it as "Y", as in the the "WANT" dataset.
I need help to produce my "WANT" dataset.
input var1 $ not_in $;
Thus, for the first row, since A is in A,B,C, then I'd like its not_in_flg to be "N".
For the second row, since D is not in A,B,C, then is not_in_flg is to be "Y".
input var1 $ not_in $ not_in_flg $;
A A,B,C N
D A,B,C Y
E B,D,A N
08-19-2017 11:09 AM
data have; input var1 $ not_in $; not_in_flg = ifc(index(not_in, trim(var1)), 'N', 'Y'); cards; A A,B,C D A,B,C E B,D,A ; proc print; run;
The last row of your example is wrong.
08-19-2017 12:51 PM
Is your data always a single character? If not use FINDW or INDEXW to search for a word and return it. Make sure to look at the later parameters for those functions to set them to ignore case or use UPCASE/LOWCASE to make everything the same case.
08-19-2017 10:25 PM
Use find function.
data have; input var1 $ not_in $; If FIND(not_in,STRIP(var1),'i')=0 then flag="Y"; ELSE Flag="N"; cards; A A,B,C D A,B,C E B,D,A ; run;