SAS Macro Proc SQL w/ Multiple Conditions
I’m trying to run a proc sql macro that contains multiple conditions strung together. Is there a way to correct the code below for the 2nd macro (rn_cnt) or is there a better approach? Background: The goal here is to generate a count of missing data file pairs by doing the following: 1.) Import the data 2.) Run a Macro to count missing records 3.) Exclude some customer IDs when the macro references the Quotes file (due to data mistakenly deleted in the past for those IDs within that file). [Note: Filenames & ID #s have been simplified due to lengthy names.] Thank you.