PARTSIZE option for SAS SPD datasets -
i've noticed when specify partsize
option when creating spd datasets in sas9.3 win7 64bit doesn't seem work intended.
i'm using simple spde libname no additional parameters. when creating dataset specify option partsize=5g
files created ~700mb. total size of combined partitions creates approximately 20g, instead of ending 4-5 partitions 20 30.
anyone else experienced or have workaround?
apparently option compress doesn't work spde expect.
this works describe:
libname mylib spde 'c:\temp' datapath=('c:\temp' 'd:\temp'); options compress=yes;; data mylib.test (partsize=5g); set sashelp.class; _t = 1 2.5e7; output; end; run;
turning options compress no yields expected results. also, in brief test, options compress didn't save time (even though 40% reduction in size), suggesting spde doesn't work optimally compress.
Comments
Post a Comment