Hallo, i came accross the macro "split2" which splits a big dataset into subgroups. The macro is also included below the message, see also http://www2.sas.com/proceedings/sugi28/075-28.pdf. It works fine to split my dataset ANALYSIS into subgroups named SAMPLE_I, with the number of I's (num) predetermined. However, i try to carry out simulation runs, with each simulation run containing its own ANALYSIS dataset. So i need to run the same macro for each simulation run, separately. i know i need to use a BY statement, but i was not able to include the BY RUN correctly. Anyone knows how to adjust the macro below by including the BY RUN statement? Any help is really appreciated. %macro split2(num); data _null_; if 0 then set ANALYSIS nobs=count; call symput('numobs',put(count,8.)); run; %let n=%sysevalf(&numobs/&num,ceil); data %do J=1 %to &num ; SAMPLE_&J %end; ; set ANALYSIS; %do I=1 %to # if %eval(&n*(&i-1)) <_n_ <= %eval(&n*&I) then output SAMPLE_&I; %end; run; %mend split2; %split2(&GROUPS);
... View more