Contains a specific string then keep this string

[mmea]

Hi 

I have a big dataset with a column that have different string in the same row seperated with a comma e.g.:

Column

test xx (0+ år),test xx 2-12 ,xx xx (0+ )

I need a code that can say if the Column contains "test xx (0+ år)," then call it "good" 

So in this case the result willl be:

column

Good

[PeterClemmensen · Accepted solution]

See if you can use this as a template

data have;
input x $50.;
datalines;
test xx (0+ år),test xx 2-12 ,xx xx (0+ )
test xx (2+ år),test xx 2-12 ,xx xx (0+ )
test xx 2-12,test xx (0+ år) ,xx xx (0+ )
;

data want;
   set have;
   if find(x, "test xx (0+ år)") then y = "Good";
run;

[mmea]

Thank you. It worked. have a good day

[PeterClemmensen]

I lige måde 🙂