DATA Step, Macro, Functions and more

i have a problem of combining 2 datasets in SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

i have a problem of combining 2 datasets in SAS

Input Dataset1:
IDNAME
x1ABC
X2xyz
X3PQR
Input Dataset2:
IDNAME
Y1AAA
Y2BBB
Y3CCC
 
Required Output:
IDNAME
x1ABC
Y1AAA
X2XYZ
Y2BBB
X3PQR
Y3CCC

Accepted Solutions
Solution
‎09-10-2017 06:10 AM
Respected Advisor
Posts: 4,925

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

Posted in reply to Kusuma001

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

PG

View solution in original post


All Replies
Solution
‎09-10-2017 06:10 AM
Respected Advisor
Posts: 4,925

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

Posted in reply to Kusuma001

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

PG
Occasional Contributor
Posts: 5

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

It works!! Thank you so much Smiley Happy

Super User
Super User
Posts: 7,050

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

[ Edited ]
Posted in reply to Kusuma001

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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 234 views
  • 0 likes
  • 3 in conversation