Hi, I am particularly new to SAS so this question may seem quite basic for some of you... I am using SAS 9.4 now. I have a number of variables that are named in the same structure (e.g. Year_1990, Year_1991, Year_1992, etc.), and my goal is to multiply the data within each of these variables (columns) by another set of year-specific data (for which I have created a list of macro variables (&M1990, &M1991, &M1992, etc.)). Since I have dozens of these variables I would like to achieve this step with a do-loop. But I am not quite sure how to set up an index system to do the calculation (something that can end up with things like Year_i = Year_i * &Mi). An example of the index construction would be particularly helpful. Thanks!
... View more