I'm not sure if there is documentation of what the list contains, but as it is an out of the box feature you should be able to just go into the data preparation tool and load it ( Tools > Load analytics stop list)   ... View more

The characters that are looked for in the data are exact matches, they do not need to be the same length. Have you tried running this will code?   Here is an example you could run for proof: proc format; value $myfmt "A" = "Something" "ABC" = "Something Else" "ABCD01"= "The Other Thing"; run; data have; length var $10; var='A';output; var='ABCD01';output; var='AB';output; run; data want; set have; new_var=put(var, $myfmt.); run; and the output   ... View more

I am not sure if this is possible in Proc SQL as SQL does not process data one row at a time in the order it is found, rather it takes chuncks of data.   If SQL is not required the the solution is possible - first remove duplicate rows then use first. and last. to flag if it is the first row of the group. Skip that row and output the next row using the lag function.    Something like this should work:   data test; input ID CODE; datalines; 1 3 1 3 1 3 2 76 2 89 2 13 3 4 run; /*noduprec will remove duplicates of id and code*/ proc sort data=test noduprec; by id; run; data second; set test; by id; if first.id and last.id then output; /*output row for single row groups*/ else if first.id then flag=1; if lag(flag)=1 then output;/*output the row after the first if more than one*/ drop flag; run; ... View more