Dear SAS community,
I have a question that needs your wisdom.
I have 30 tables, say Table1,table2,...table 30. All of them have the same data structure and the same list of variables (which includes a variable name GOOD) except that the ith table denotes the month i.
Now I need to create a new table X, which is composed of two columns/variables.
The first variable of table X is i, the index for table i; the second variable of table X is the means of variable GOOD for table i.
Does any one can point me to any idea/procedure/SAS macro that achieve this?
Rather than
Thanks in advance!!!