topic Re: i have a problem of combining 2 datasets in SAS in SAS Programming

i have a problem of combining 2 datasets in SAS

Kusuma001 — Sat, 09 Sep 2017 05:36:17 GMT

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

Re: i have a problem of combining 2 datasets in SAS

PGStats — Sat, 09 Sep 2017 06:23:48 GMT

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

Re: i have a problem of combining 2 datasets in SAS

Kusuma001 — Sat, 09 Sep 2017 06:34:22 GMT

It works!! Thank you so much 🙂

Re: i have a problem of combining 2 datasets in SAS

Tom — Sun, 10 Sep 2017 04:03:28 GMT

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