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
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 ;
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 ;
Yes, you were right! I was simply missing a semicolon.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.