topic Re: Toggle the set in/not in by using Marco function. in SAS Programming

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

sarahzhou — Fri, 20 Jan 2023 07:43:35 GMT

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!

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

PeterClemmensen — Fri, 20 Jan 2023 07:58:50 GMT

This macro creates only 1 table?

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

sarahzhou — Fri, 20 Jan 2023 08:33:40 GMT

yes, this macro creates one table.

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