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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.