I prefer DATA step to SQL, but there is probably a way to do it with SQL too 🙂
data work.test;
set &em_import_data;
drop %em_rejected;
run;
Note for this to work, you need to set the Hide Rejected Variables property in the Variable Selection node to No, then in the Variables editor for the SAS Code node, set Use=Yes for all variables.
... View more
