topic Re: In list with scan function in SAS Programming

In list with scan function

JediApprentice — Fri, 27 May 2016 15:40:51 GMT

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 — Fri, 27 May 2016 15:43:03 GMT

Show the log...

ballardw — Fri, 27 May 2016 16:12:44 GMT

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 — Fri, 27 May 2016 16:19:20 GMT

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