My program generates a single observation and, as the last step, appends this single observation to a results file (RESULTS1). The results file starts empty. I want to save every individual result but limit the size of the results file to 100,000 observations. The observation generated by the 100,001th iteration would be automatically written to a new (empty) results file (Results2) again, up to 100,000 in size. The 200,001th observation would go to another new results file (lets call it Results3) etc....So, in the end, if I run 350,000 iterations, I will end up with RESULTS1 (100,000 obs), RESULTS2 (100,000 obs), RESULTS3 (100,000 obs), RESULTS4 (50,000 obs)
Think of it as: I have five gallons of results that pour into a container one drop at a time, but I have pint sized containers so when one is full, the conveyor belt moves to next container and starts to fill it (and never miss a drop).
How can I limit the size of the results file, keep it, and then start a new one with a sequential name?
Thanks
proc append base=RESULTS1 data=newestresult force;
run;
... View more