The proc sql at the start of macro check has nowhere to write the result of its select statement.
Open a destination or write to a table.
The mail error is a different matter and I expect that your EG server has the email configured when our desktop SAS doesn't.
Ask your SAS admin for the email parameters.
... View more