How to union multiple data query in SAS VA

[Carrot17]

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,

[AnnaBrown]

Hi Carrot17,

Did you get your answer in this thread?

How to do Union in Data preparation

If so, please mark the correct or helpful answer as you see fit.

Best,

Anna