Thanks very much for taking the time to look at this . I should have been more prescriptive in my initial example and mentioned that the length of the text after 'cn=' can be a different length each time . e.g. data have;
length string $200.;
id=111;
string = 'xxx,xxcn=test1,yyy,zz,cn=test2,dfd'; output;
id=222;
string = 'xadfds , xx,xxcn=test3,yyy,zz,cn=test2,dfd'; output;
id=333;
string = 'xadfds , xx,xxcn=test3,yyy,zz,cn=somthingdiff,dfd'; output;
run; But I can use your example to get what I need thanks
... View more