Toggle the set in/not in by using Marco function.

[sarahzhou]

Hi,

I want to create two tables where the id_key may or may not in another table.

I coded as below,

%macro table(out_table,not_in,key_in_other_table);
Proc sql;
Create table &out_table. As 
select * from table_A 
Where id_key &not_in. in (select id from &key_in_other_table.)
Quit;
%mend;

How can I toggle the Boolean variable NOT in the macro function?

Please advise.

Thank you!

[PeterClemmensen]

This macro creates only 1 table?

[sarahzhou]

yes, this macro creates one table.

I want a freedom to create table that id not in a table as well.