Add FILEBUFNO option for optimizing external input performance
on 11-28-201402:03 PM - last edited on 10-10-201509:39 PM by LainieH
With DATA step and INFILE processing, SAS has a hardcoded internal setting for an equivalent option to FILEBUFNO=5 -- one that cannot be influenced by the SAS user / admin / site. There are instances, present in IBM z/OS mainframe environment, where a higher value for external input data is preferred, for significantly improved performance (as in reduced elapsed time to process large-volume input data streams.) In the particular case, no external JCL DD allocations are performed, instead INFILE is used along with the FILEVAR= specification, resulting in dynamic allocation (SVC 99). Unfortunately, this approach does not provide a means to override the z/OS BUFNO= setting for the input data reading. This limitation has been confirmed with SAS Tech Support, as of SAS 9.4 TS1M2.
We would like to see a CONFIG setting added for FILEBUFNO, and as well provide INFILE statement support. We realized that the FILENAME statement does provide a BUFNO= parameter -- the use of FILENAME statement is not suitable and the INFILE / FILEVAR approach is appropriate.