Exactly, in my company business users are familiar with queries in a BI application through a drag&drop approach. They can copy the oracle query code that runs in the backgroups and plug it in in the sas code like you decribed.  It's a huge time saver and we have the data directly in sas building up on the users' expertise to make the query and put the filters they require.   ... View more