Sort by patient_id.
Run this data step:
data intermediate;
set have end=eof;
by patient_id;
retain counter 0 ds_counter 1;
counter + 1;
if first.patient_id and counter ge 20000
then do;
ds_counter + 1;
counter = 1;
end;
if end then call symputx('num_ds',ds_counter);
drop counter;
run;
You now have the maximum number of datasets in the macro variable (for use in a %do loop), and an indicator in every observation where it should go.
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
