In list with scan function

[JediApprentice]

I'm trying to see if a string that is returned by a scan function can be checked for in a list of strings as such:

if scan(CAG_code,3,"$") in("5234E","4321B","4456C")  --> this is throwing a syntax error

an example of what CAG_code looks like is: 2286$2983$4456C

[LinusH]

Show the log...

[ballardw · Accepted solution]

No error with this:

data junk;
   CAG_code= '2286$2983$4456C';
   if scan(CAG_code,3,"$") in("5234E","4321B","4456C") then put 'Found';
run;

Log and error message please.

My $0.02 guess: error on previous line such as missing ;

[JediApprentice]

Yes, you were right! I was simply missing a semicolon.