Hi All,   I have several tables named, test_table_0511, test_table_0518 etc. The tables are labelled at 7 day intervals in the format MMDD. All columns are the same.   I want to just join them all together in a master table and have a date column which specifies from the end of the table name what the date was when the table was made.   I don't know SAS well (at all) and so far I just used proc sql to manually union them all together which would take too long for how many I have:   PROC SQL; SELECT *, '0511' AS Date  FROM test_table_0511  UNION SELECT *, '0518' AS Date  FROM test_table_0518  etc etc  run;   Expected Output    Master Table:   Var 1  Var 2 Var 3 Date 58.96% 44.58% 78.49% 0511 59.45% 6.69% 23.92% 0511 57.12% 62.65% 58.64% 0511 69.28% 82.95% 80.13% 0511 71.47% 30.57% 40.17% 0511 45.57% 39.50% 89.19% 0518 74.68% 24.12% 98.68% 0518 89.52% 16.49% 64.53% 0518 56.59% 98.23% 72.71% 0518 6.95% 29.76% 0.96% 0518 11.92% 62.55% 59.95% 0525 86.99% 3.39% 79.00% 0525 59.97% 42.44% 80.71% 0525 45.70% 82.67% 95.15% 0525 43.74% 15.02% 24.36% 0525   Anyone have any suggestions?   Thanks very much      ... View more