I suggest starting here:  Managing Access to Functionality  ... View more

Have you tried using the noprompt option?   Have you tried using the filedsn option ? See: http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p0bu3zsz1a08ton1msxdx1jo45np.htm   Have you read the similar questions and answers here? Like: https://communities.sas.com/t5/SAS-Procedures/LIBNAME-ODBC-with-NOPROMPT-option-on-Unix/td-p/199696 ... View more

Have a look at the SAS Batch Relationship Reporting Tools. Gerry Nelson from SAS wrote a blog post about them at https://blogs.sas.com/content/sgf/2015/03/04/relationships-are-easy-for-sas-objects/   You might also be interested in the point and click SAS BI Lineage Plug-in. ... View more