An Idea Exchange for SAS software and services

by Respected Advisor
on ‎05-07-2013 08:25 PM
This is not the best place to ask a question, try creating a discussion next time.
end=final sets variable final to zero until the end of the dataset is reached when final is set to one. You could use do i = 1 by 1 until(final); or you could get rid of the loop
data prac2; set orion.order_fact; rank=cats("Top",_n_); run; - PG
by Valued Guide
on ‎11-30-2014 11:23 AM

scott, do not forget to vote yourself.  Maybe SMS routines could do a lot, it is not in the oldies anymore of all coding all attributes yourself.  

by Super Contributor
on ‎11-30-2014 11:38 AM

Thanks for the vote reminder....

Unfortunately, the SMS DATACLAS attribute provides no means of supplying BUFNO though.  Of course it is at least documented by SAS INSTITUTE anyway as being a hardcoded default-assigned when not controlled either by JCL DD or FILENAME statement method.  As I demonstrated to SAS Tech Support, the potential elapsed-time performance gain is significant, if we could only influence the BUFNO=5 SAS-default when using INFILE / FILEVAR= technique, with a large-volume data input, such as DB2 SMF 101 records in the 10-50 million (multiple times per business day).

by Valued Guide
on ‎11-30-2014 01:35 PM

I am convinced that all type of buffering should be as closest to the data-processing as possible with tunable options.  (in generic)

Your proposal is belonging to that.

There are a lot of people believing that generic approaches knowing nothing of the data-process are better. The can add something (caching in the device) but too late too far away.

Just preparing for those kind of comments.      

by Super Contributor
on ‎11-30-2016 12:10 PM

Thank you, SAS INSTITUTE for listening (sort of).

Recently, with SAS 9.4 TS1M4, SAS has enhanced INFILE/FILE processing by allowing BUFNO=5|nn  to be coded for likely (some) elapsed-time performance gain -- we were hoping to see a different-named parameter FILEBUFNO= for INFILE/FILE, so as not to be confused with either/both the CONFIG/OPTIONS parameter BUFNO=nn  which only pertains to SAS dataset / member performance.  And we look forward to the CONFIG/OPTIONS "global" setting for a FILEBUFNO=5|nn -- mostly for SAS z/OS and with the INFILE <fileref>  FILEVAR=<filename>  ;   usage, involving dynamic-allocation (SVC99).


Scott Barry

SBBWorks, Inc.


Idea Statuses
Top Liked Authors