How can we match anywhere (any observation) between var1 and var2 from both dataset, and create YES/NO flag is it match     data a; infile datalines truncover; input va1 $80.; datalines; 1577026 1577026,239684,239696,240005,318992,1577026,924616,924749 924767,924652,1208821 924767,924652,1208821 ; run;   data b; infile datalines truncover; input va2 $80.; datalines; 239684,239696,240005,318992,1577026,924616,924749,1577026 12345 924767,924652 924767,924652,1208821 ; run;     /*result - Match flag*/   ... View more

Q: What is the maximum number of "ids" that may occur in var1 and var2? Are all of the ids exactly 7 characters? Some longer? What is the number of characters in the longest id?   Ans: The maximum number of IDs in var1 and var2 cab ne 20 Id characters can be between 2-12 character long   Q: If you have 1) the same number elements in each variable, 2) there are 20 or fewer elements and 3) each id is no longer than 7 characters this may work for you:   Ans: 1) it can be different  2) yes 20 and fewer elements 3) each id can be between 2-12 character long ... View more

I am comparing observation to observation, Please see below,   data a; input id va1 $80.; datalines; 1  1577026,239684,239696,240005,318992,1577026,924616,924749 2  1577026 3  924767,924652,1208821 4  924767,924652,1208821 ; run;   data b; input id va2 $80.; datalines; 1  239684,239696,240005,318992,1577026,924616,924749,1577026 2  12345 3  924767,924652 4  924767,924652,1208821 ; run;   /*result - Match flag*/ ID  Match_flag 1  YES 2  NO 3  NO 4  YES ... View more