topic Re: How to merge several dataset by row in SAS Procedures

How to merge several dataset by row

newone — Mon, 04 Dec 2017 03:13:12 GMT

I need to put observations in five dataset into one dataset. I usually use macro and loop, each time with data step setting two dataset. I think this way is not efficient. Does anyone have a better solution to merge five dataset in one piece of code? The variables sometime do not have the same name. But they are the same thing. It is basically just putting observations in different dataset into the same dataset. Thanks!

Re: How to merge several dataset by row

PGStats — Mon, 04 Dec 2017 05:18:34 GMT

If by merge you mean concatenate then use rename to get uniform names and simply list the datasets in a set statement:

data all;
set
    dset1 (rename=(oldvar1=newvar))
    dset2 (rename=(oldvar2=newvar))
    dset3 (rename=(oldvar3=newvar))
    dset4 (rename=(oldvar4=newvar))
    dset5 (rename=(oldvar5=newvar));
run;