topic Re: union query in SAS in SAS Programming

union query in SAS

GN0001 — Thu, 13 May 2021 23:12:31 GMT

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 — Thu, 13 May 2021 23:58:03 GMT

DATA step is easiest:

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

ballardw — Fri, 14 May 2021 00:02:12 GMT

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

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

data want; set MyLib.have: ; run;

GN0001 — Fri, 14 May 2021 05:18:06 GMT

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

ballardw — Fri, 14 May 2021 16:56:27 GMT

@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.