SQL Logic to Fail a Check if Any of the Related Customers Have Failed

Understanding Date Literals and Converting Values for Effective Filtering in PROC SQL and Teradata