General form, BUFSIZE=
option:
BUFSIZE= MIN | MAX | n;
MIN
sets the page size
to the smallest possible number in your operating environment.
MAX
sets the page size
to the maximum possible number in your operating environment.
n
specifies the page
size in bytes. For example, a value of 8 specifies a page size of
8 bytes, and a value of 4K specifies a page size of 4096 bytes. The
default is 0, which causes SAS to use the optimal page size for the
operating environment.
|
options bufsize=30720;
filename orders 'c:orders.dat';
data company.orders_fact;
infile orders;
<more SAS code>
run;
General form, BUFNO=
option:
BUFNO= MIN | MAX |n;
MIN
causes
SAS to use the minimum optimal value for the operating environment.
This is the default.
MAX
sets the number of
buffers to the maximum possible number in your operating environment,
up to the largest four-byte, signed integer, which is 2³¹-1,
or approximately 2 billion.
n
specifies the number
of buffers to be allocated.
|
options bufno=4; filename orders 'c:orders.dat'; data company.orders_fact; infile orders; <more SAS code> run; proc print data=company.orders_fact; run;
BUFSIZE
|
BUFNO
|
Bytes Transferred in
One I/O Operation
|
---|---|---|
6144
|
2
|
12,288
|
6144
|
10
|
61,440
|
30,720
|
2
|
61,440
|
30,720
|
10
|
307,200
|
BUFSIZE=6144, BUFNO=2 This program reads the
data set Retail.Order_fact and creates the data set Work.Orders. The
BUFSIZE= option specifies that Work.Orders is created with a buffer
size of 6144 bytes. The BUFNO= option specifies that 2 pages of data
are loaded into memory with each I/O transfer.
data work.orders (bufsize=6144 bufno=2);
set retail.order_fact;
run; |
BUFSIZE=6144, BUFNO=5 This program reads the
data set Retail.Order_fact and creates the data set Work.Orders. The
BUFSIZE= option specifies that Work.Orders is created with a buffer
size of 6144 bytes. The BUFNO= option specifies that 5 pages of data
are loaded into memory with each I/O transfer.
data work.orders (bufsize=6144 bufno=5);
set retail.order_fact;
run; |
BUFSIZE=6144, BUFNO=10 This program reads the
data set Retail.Order_fact and creates the data set Work.Orders. The
BUFSIZE= option specifies that Work.Orders is created with a buffer
size of 6144 bytes. The BUFNO= option specifies that 10 pages of data
are loaded into memory with each I/O transfer.
data work.orders (bufsize=6144 bufno=10);
set retail.order_fact;
run; |
BUFSIZE=12288, BUFNO=2 This program reads the
data set Retail.Order_fact and creates the data set Work.Orders. The
BUFSIZE= option specifies that Work.Orders is created with a buffer
size of 12288 bytes. The BUFNO= option specifies that 2 pages of data
are loaded into memory with each I/O transfer.
data work.orders (bufsize=12288 bufno=2);
set retail.order_fact;
run; |
BUFSIZE=12288, BUFNO=5 This program reads the
data set Retail.Order_fact and creates the data set Work.Orders. The
BUFSIZE= option specifies that Work.Orders is created with a buffer
size of 12288 bytes. The BUFNO= option specifies that 5 pages of data
are loaded into memory with each I/O transfer.
data work.orders (bufsize=12288 bufno=5);
set retail.order_fact;
run; |
BUFSIZE=12288, BUFNO=10 This program reads the
data set Retail.Order_fact and creates the data set Work.Orders. The
BUFSIZE= option specifies that Work.Orders is created with a buffer
size of 12288 bytes. The BUFNO= option specifies that 10 pages of
data are loaded into memory with each I/O transfer.
data work.orders (bufsize=12288 bufno=10);
set retail.order_fact;
run; |