Hello, I have a SAS dataset that has a column that needs to be multiplied by other columns within the dataset to create a new column for each multiplication. The problem is, this needs to be repeatable and will have a different number of columns each time. In my example, I have 3 numbers that I need my expected_volume column to be multiplied by. What I have: What I want: Is there any way to achieve this so that it is repeatable no matter how many value columns there are? So far I was thinking that I could do this with a macro like below, but I am not sure how to get it to repeat for the amount of times I need it to each time. Is this possible to do in a do loop? %macro repeat(num); data matrix; set matrix; product&num. = expected_volume * value&num.; run; %mend; %repeat(1); Thanks for any advice!
... View more