For seven categories, I would not even think about a macro, just brute force program this as in my earlier example. So
data have2;
set have(where=(max3=1) rename=(n=n1 signs=signs1))
have(where=(max3=2) rename=(n=n2 signs=signs2))
have(where=(max3=3) rename=(n=n3 signs=signs3))
have(where=(max3=4) rename=(n=n4 signs=signs4))
have(where=(max3=5) rename=(n=n5 signs=signs5))
have(where=(max3=6) rename=(n=n6 signs=signs6))
have(where=(max3=7) rename=(n=n7 signs=signs7));
run;
proc sgplot data=have2;
scatter x=n1 y=signs1/transparency=0.2;
scatter x=n2 y=signs2/transparency=0.8;
/* Additional scatter statements go here, I left them out to save me some typing */
run;
where I assume the values of max3 are 1 to 7 (if they are not 1 to 7, then make the obvious change to the code above).
... View more
