Have you checked the configuration of LB's Configuration properties like ?
-Ddfs.balance.bandwidthPerSec
When you're running a query for large table in Hadoop from SAS, SAS will automatically use READ_METHOD=HDFS which means SAS is directly connecting to the HDFS Load Balancers or HDFS Data Nodes, SAS retrieves these values from SAS_HADOOP_CONFIG_PATH Environment Variable For more information refer this link: https://documentation.sas.com/?docsetId=hadoopbacg&docsetTarget=p15adw95cc9397n1drnqztusgdwp.htm&docsetVersion=3.2&locale=en
You can check core-site.xml, hdfs-site.xml files to get an idea that which LB, Data Nodes and SPNs SAS is using to connect to the Hadoop;
About SAS connection to the Hadoop, it uses Hadoop Jar Files and Conf files retrieved from Hadoop, you can refer this link for more info:https://documentation.sas.com/?docsetId=hadoopov&docsetTarget=n1gtt90tf28i1an1flr3c6a8yr3t.htm&docsetVersion=9.4&locale=en
... View more