Hi @Beartato
Just for fun...
data old;
input ResponseID Variable1 Variable2 Variable3 Variable4 Variable5;
cards;
1 50 50 50 45 0
2 100 90 80 70 60
3 20 0 0 0 0
4 0 0 0 0 0
5 100 100 100 100 100
run;
data new;
input ResponseID Variable6 Variable7;
cards;
4 10 10
2 50 25
1 60 30
5 100 100
3 0 0
run;
proc sql;
create table merged_data as
select o.ResponseID, o.Variable1, o.Variable2, o.Variable3, o.Variable4, o.Variable5 , n.Variable6, n.Variable7
from old o,
new n where o.ResponseID = n.ResponseID
order by o.ResponseID;
quit;
... View more
