The issue is that my business users are not SAS proficient and don't have time to learn it. Generating the SQL to create the dataset using VBA is simple. And your solutions do not rely on one technology either. My solution only requires a user to open the excel file, select some drop-downs and click a button. I've done it before it's just a matter of setting up the connection. I appreciate the response.
... View more