Hello! I'm attempting to use macro variables to track versioning in my programs. Ideally, the end product would be an output file with names and version dates for each of my programs. I've added a global macro variable to each program that stores the version date. For example: %LET Prog1_Vsn=%STR(2020.02.21); I have a dataset with a column for the name of this macro variable, the full program name, and a description. For example: MacroVar Name Desc &Prog1_Vsn Program 1 First program in set I would like SAS to create a new variable that resolves the macro variable listed in the dataset, like this: MacroVar Name Desc Version &Prog1_Vsn Program 1 First program in set 2020.02.21 Is this possible? Is there a better way to achieve this result? I'm using base SAS 9.4. Many thanks for any help! PS- I do realize that I can hard-code this by using something like IF name = "Program 1" THEN Version = "&Prog1_Vsn". I would like a smarter solution, if at all possible.
... View more