/*
OK. Check this one .
*/
data have;
length ID $ 10 VariableList $ 50;
infile cards dsd dlm='|' truncover ;
input ID VariableList;
datalines;
A1|stringA13 stringBC9 123
A2|stringA13 + stringBC9 > stringC
A3|stringA13
A4|stringBC9 stringC 456
A5|stringC stringD abc
A6|stringBC8 stringD abc
A7|stringBC8 stringA2 abc
A8|stringA13 stringBC9
;
data want;
set have;
if prxmatch('/string(?!A13|BC9)/i',VariableList) then delete;
run;
... View more
