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

I have a macro variable defined inside a program (program1) for a fudge factor.   %LET fudge = 1.00; When I run that program as a standalone, I want it to remain at 1.00.   However, I have another program (program2) that calls up and runs program1 several times; each time replacing the value of fudge factor.    %LET fudge = 1.01; /* Total number in subset */ %include "&PATH\&hmprog"; %include "&PATH\&usprog"; %LET fudge = 1.02; /* Total number in subset */ %include "&PATH\&hmprog"; %include "&PATH\&usprog"; %LET fudge = 1.03; /* Total number in subset */ %include "&PATH\&hmprog"; %include "&PATH\&usprog"; %LET fudge = 1.04; /* Total number in subset */ %include "&PATH\&hmprog"; %include "&PATH\&usprog"; %LET fudge = 1.05; /* Total number in subset */ %include "&PATH\&hmprog"; %include "&PATH\&usprog"; While I can manually edit the called program1 to delete the " %LET fudge = 1.00; " line and resave, I was hoping there was a way to avoid that.  That is, to have the macro variable's value in program2 override the 1.00 value in program1 without having to manually edit that line out and resave (and then reverse it when I want to run program1 as a standalone).   Thanks ... View more

Is there an easy way to create a dataset with one observation and one variable, where the value is the number of obs in another dataset?   Thanks ... View more