%macro search_nolast(datadset1,dataset2);
proc sql;
create table search.nolast&dataset2 as
select * from search.&dataset1
where customer_name not in (select customer_name from search.&dataset2);
quit;
%mend ;
NOTE: 由调用宏“SEARCH_NOLAST”生成行。
1 create table search.nolast&dataset2 as select * from search.&dataset1 where
-
22
200
1 ! customer_name not in (select customer_name from search.&dataset2); quit;
WARNING: 没有解析符号引用 DATASET1。
ERROR 22-322: 期望: 名称.
ERROR 200-322: 该符号不可识别,将被忽略。