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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.