Altair SLC Benchmarking sas7bdat creation versus wpd dataset creation

Roger DeAngelis_21630

Creating 128,000,000 observations

sas7bdat 30 seconds

wpd 21 seconds

inp.sas7bdat

NOTE: Data set "WPDE.inp" has 128000000 observation(s) and 10 variable(s)
NOTE: The data step took :
real time : 30.206
cpu time : 30.140

inp.wpd

NOTE: Data set "WPDE.inp" has 128000000 observation(s) and 10 variable(s)
NOTE: The data step took :
real time : 20.877
cpu time : 20.718

libname wpde wpd "e:/spde";

data wpde.inp;
array states[8] $2 ("TN","TX","UT","VT","MD","MA","MI","MN");
do s=1 to dim(states);
state=states[s];
do i=1 to 1600e4;
ran=uniform(65432);
output;
end;
end;
drop s i;
stop;
run;

libname wpde sas7bdat "e:/spde";
data wpde.inp;
array states[8] $2 ("TN","TX","UT","VT","MD","MA","MI","MN");
do s=1 to dim(states);
state=states[s];
do i=1 to 1600e4;
ran=uniform(65432);
output;
end;
end;
drop s i;
stop;
run;