topic LIKE operator not working - if then else in SAS Enterprise Guide

LIKE operator not working - if then else

anonymous_user — Fri, 15 Apr 2022 16:49:32 GMT

5         
96         /*put into 3 buckets*/
97         data claims2;
98         set claims;
99         if PracticeName="Unknown" then ProvCategory="Not MMM";
100        else if PracticeName like "SonorTouch%" then ProvCategory="SonorTouchTech";
                                ____
                                388
                                76
ERROR 388-185: Expecting an arithmetic operator.

ERROR 76-322: Syntax error, statement will be ignored.

101        else ProvCategory="Private";
102        run;

IS there something else to use other than like?

Re: LIKE operator not working - if then else

ballardw — Fri, 15 Apr 2022 17:03:23 GMT

LIKE only works in Proc SQL or the WHERE clause in a data step

If you want to check to see if a value begins with a specific text value use:

else if PracticeName =: "SonorTouch" then ProvCategory="SonorTouchTech";

Note the : after the =, that means "begins with"

Re: LIKE operator not working - if then else

anonymous_user — Fri, 15 Apr 2022 17:15:13 GMT

Thank you!