Hi,
I would like to ask how to union multiple data query in SAS VA. Please see example table below. Thank you.
Input Table 1
ID | Level | Group | Amount |
---|
01 | Level 1 | Group 1 | 51 |
02 | Level 1 | Group 1 | 35 |
03 | Level 1 | Group 2 | 21 |
Input Table 2
ID | Level | Group | Amount |
---|
04 | Level 2 | Group 3 | 11 |
05 | Level 2 | Group 3 | 26 |
Input Table 3
ID | Level | Group | Amount |
---|
06 | Level 3 | Group 4 | 17 |
07 | Level 3 | Group 5 | 18 |
08 | Level 3 | Group 5 | 19 |
Expected Output
ID | Level | Group | Amount |
---|
01 | Level 1 | Group 1 | 51 |
02 | Level 1 | Group 1 | 35 |
03 | Level 1 | Group 2 | 21 |
04 | Level 2 | Group 3 | 11 |
05 | Level 2 | Group 3 | 26 |
06 | Level 3 | Group 4 | 17 |
07 | Level 3 | Group 5 | 18 |
08 | Level 3 | Group 5 | 19 |
Regards,