ID | NAME |
x1 | ABC |
X2 | xyz |
X3 | PQR |
ID | NAME |
Y1 | AAA |
Y2 | BBB |
Y3 | CCC |
ID | NAME |
x1 | ABC |
Y1 | AAA |
X2 | XYZ |
Y2 | BBB |
X3 | PQR |
Y3 | CCC |
data want;
set dataset1; output;
set dataset2; output;
run;
It works!! Thank you so much 🙂
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.