I am having a very hard time following you, I initially asked why the user created function that was supplied to me would remove periods between words within one of my inputs. In the example utilization of the SET_IN_CLAUSE macro there is no mention of formatting your input with an ampersand before the variable. Below is the example provided in the macro code. proc sql;
create table FILTERED as
select *
from SASHELP.CLASS
where ( %set_in_clause(dsin=FILTER(firstobs=2), varin=ID, varout=AGE, maxnb=1000) );
quit; When I follow that format I get the error I described in this subthread. So I am not following what your suggestion is. Are you familiar with the user macro I am using and are saying the documentation example on how to enter data into it is incorrect? Or are you telling me how to troubleshoot the results and figure out where in the macro the periods of my input are being removed? proc sql;
create table FILTERED as
select *
from SASHELP.CLASS
where ( %set_in_clause(dsin=FILTER(firstobs=2), varin=core.db.table.element, varout=AGE, maxnb=1000) );
quit;
... View more
