Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to union multiple data query in SAS VA

Reply
Contributor
Posts: 54

How to union multiple data query in SAS VA

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

IDLevelGroupAmount
01Level 1Group 151
02Level 1Group 135
03Level 1Group 221

Input Table 2

IDLevelGroupAmount
04Level 2Group 311
05Level 2Group 326

Input Table 3

IDLevelGroupAmount
06Level 3Group 417
07Level 3Group 518
08Level 3Group 519

Expected Output

IDLevelGroupAmount
01Level 1Group 151
02Level 1Group 135
03Level 1Group 221
04Level 2Group 311
05Level 2Group 326
06Level 3Group 417
07Level 3Group 518
08Level 3Group 519

Regards,

Community Manager
Posts: 544

Re: How to union multiple data query in SAS VA

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

Ask a Question
Discussion stats
  • 1 reply
  • 306 views
  • 1 like
  • 2 in conversation