%MACRO complete (total =, excerpt1 =, out =) ; PROC SQL ; CREATE TABLE &out AS SELECT * FROM &total WHERE _index_ NOT IN ( SELECT _index_ FROM &excerpt1) ; QUIT ; %MEND complete ;