I'd like tha data split by 100k with the remaining in its own data set. So for this one it would be: Main Table - 360,000 rows into Table1 100,000 Table2 100,000 Table3 100,000 Table4 60,000 I just need it split by the number of row, variables are not driving it. I wouldnt expect the Main table to get larger than 500,000 rows. i was looking into this: http://www2.sas.com/proceedings/sugi28/075-28.pdf But I could not get it working...i'm sure i am missing quite a few steps, but here is what i tried: %split(TQ_AcctNum)/* creating a dataset with 100000 observations*/ data dsn; do i= 1 to 100000; output; end; run; %macro split(dsn,splitby); data _null_; set &dsn nobs=num; call symput('no_obs',num); run; %letno_obs=&no_obs; %doi= 1 %to %sysfunc(ceil(&no_obs/&splitby)); data dsn&i; set &dsn (firstobs=%sysfunc(floor(%eval((&i.-1)*&splitby.+1))) obs=%sysfunc(ceil(%eval(&i * &splitby.)))); run; %end; %mend; %split(dsn,10000);
... View more