Not sure how fancy you want to be or the simple way would be something like using arrays.. data x; set corout; array ax{*} x1-x3; array px{*} p1-p3; row+1; do j=row to len(px) if px{j}<0.05 then do; if ax{j}<0 then sumneg+1; if ax{j}>0 then sumpos+1; end; run; Since I am at home and don't have sas this is just a guess to the syntax. Hopefully you know how to do arrays. What you want to do is in the first row compare x1 to x2 and x1 to x3, count the number significant p values then check the correlations to see if they are negative or positive. The second record you want to start with x2 then compare with x3 then check for significance the neg and positive. Hope this helps.
... View more