Ah ok. Do like this instead.
data ds1;
input x @@;
datalines;
1 2 3
;
data ds2;
input x @@;
datalines;
4 5 6
;
data want;
do i=1 to max(nobs1,nobs2);
set ds1 nobs=nobs1 point=i; output;
set ds2 nobs=nobs2 point=i; output;
end;
stop;
run;
Assuming the variables have the same name (In this example x)
data ds1;
input x @@;
datalines;
1 2 3
;
data ds2;
input x @@;
datalines;
4 5 6
;
data want;
set ds1 ds2;
run;
Ah ok. Do like this instead.
data ds1;
input x @@;
datalines;
1 2 3
;
data ds2;
input x @@;
datalines;
4 5 6
;
data want;
do i=1 to max(nobs1,nobs2);
set ds1 nobs=nobs1 point=i; output;
set ds2 nobs=nobs2 point=i; output;
end;
stop;
run;
Anytime 🙂
data ds1;
input x @@;
datalines;
1 2 3
;
data ds2;
input x @@;
datalines;
4 5 6
;
data want(keep=x);
set ds1; set ds2(rename=(x=x1));
output;
x=x1;
output;
run;
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.