Hi, I am recently learning SAS by doing project for my advisor. Could anyone can help me figure out what is wrong with my code and how to fix it? proc sql noprint; /*firmid is a macro var containing values of udbnum from temp*/ select udbnum into: firmid separated by ',' from temp; quit; Then I want to refer to elements in firmid using the following code %let fid=%sysfunc(strip(%sysfunc(scan(&firmid,1,',')))); In the real problem, I actually used a loop to scan all the elements in firmid, but the error is the same when I simply put 1,2,3, ... in the scan function ERROR: The function SCAN referenced by the %SYSFUNC or %QSYSFUNC macro function has too many arguments. ERROR: The function STRIP referenced by the %SYSFUNC or %QSYSFUNC macro function has too few arguments. I will really appreciate it if someone can help.
... View more