topic Re: Contains a specific string then keep this string in New SAS User

Contains a specific string then keep this string

mmea — Wed, 16 Dec 2020 09:33:43 GMT

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

Re: Contains a specific string then keep this string

PeterClemmensen — Wed, 16 Dec 2020 09:39:35 GMT

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;

Re: Contains a specific string then keep this string

mmea — Wed, 16 Dec 2020 09:42:52 GMT

Thank you. It worked. have a good day

Re: Contains a specific string then keep this string

PeterClemmensen — Wed, 16 Dec 2020 09:54:31 GMT

I lige måde 🙂