i have a problem of combining 2 datasets in SAS

[Kusuma001]

Input Dataset1:

ID	NAME
x1	ABC
X2	xyz
X3	PQR

Input Dataset2:

ID	NAME
Y1	AAA
Y2	BBB
Y3	CCC

Required Output:

ID	NAME
x1	ABC
Y1	AAA
X2	XYZ
Y2	BBB
X3	PQR
Y3	CCC

[PGStats · Accepted solution]

data want;
set dataset1; output;
set dataset2; output;
run;

[Kusuma001]

It works!! Thank you so much 🙂

[Tom]

Why that order?

If you need to be able to preserve or recreate that order then you need another variable.

data ds1 ;
  group +1 ;
  input id $ name $ ;
cards;
x1	ABC
X2	xyz
X3	PQR
;
data ds2;
  group +1 ;
  input id $ name $ ;
cards;
Y1	AAA
Y2	BBB
Y3	CCC
;
data want ;
  set ds1 ds2 ;
  by group;
run;

Otherwise the first time you sort your new dataset the interleave of the X's and the Y's will be lost.

Obs    group    id    name
 1       1      x1    ABC
 2       1      Y1    AAA
 3       2      X2    xyz
 4       2      Y2    BBB
 5       3      X3    PQR
 6       3      Y3    CCC