union query in SAS

[GN0001]

Hello team,

I have 6 tables that they have same variable names:

MembrID Name diagcode1 diagcode2;

I want to append these table like union query in Microsoft Access.

-How can I get there if I want to create a loop and goes through the name of the tables? The tables share same libname.

Respectfully,

Blue Blue

[SASKiwi · Accepted solution]

DATA step is easiest:

data want;
  set MyLib.have1 MyLib.have2 MyLib.have3 MyLib.have4 MyLib.have5 MyLib.have6;
run;

[ballardw]

And if the names of the data sets are actually "nice" enough to use lists:

data want;
  set MyLib.have1 - MyLib.have6;
run;

Or

data want;
  set MyLib.have: ;
run;

[GN0001]

SASKiwi,
Does this take care of stacking data on top of each other?
Does this return all duplicated observations?
Regards,
Blue Blue

[ballardw]

---

@GN0001 wrote:
SASKiwi,
Does this take care of stacking data on top of each other?
Does this return all duplicated observations?
Regards,
Blue Blue

---

It stacks all of the data including duplicate observations.