Background: I am conducting a sensitivity analysis where I am looping over combinations of two parameters A and B, where A=1,2 and B=1 to 9. I have saved down datasets for each of the 18 combinations of the two parameter values and I now would like to write a macro the generate summary statistics, by group, for 6 output variables I am interested in. Problem: If I limit B to B=1 to 8 I get the 16 desired output datasets, however if I loop over B=1 to 9 I inexplicably get 21 output datasets, where the the output for the output for some iterations is duplicated, and trying to open the duplicates produces an error: "Cannot open dataset, file does not exist". Although I do ultimately get the desired output, there must be something going wrong to produce the additional duplicate datasets. Example code: data data;
input group $ var1-var6;
datalines;
group1 1 2 3 4 5 6
group2 7 8 9 10 11 12
;
run;
%macro example;
%do i = 1 %to 2;
%do j = 1 %to 9;
%let case = A&i._B&j.;
data case_A&i._B&j.;
set data;
case = "&case.";
run;
%end;
%end;
%mend;
%example Any help would be greatly appreciated.
... View more