https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418676#M26953 <P>Hi All,</P><P>&nbsp;</P><P>I have a sas program with 15 datasets which I would like to merge by ID. Can you please suggest a macro?</P> Wed, 06 Dec 2017 05:53:01 GMT sas_enthu 2017-12-06T05:53:01Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418676#M26953 <P>Hi All,</P><P>&nbsp;</P><P>I have a sas program with 15 datasets which I would like to merge by ID. Can you please suggest a macro?</P> Wed, 06 Dec 2017 05:53:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418676#M26953 sas_enthu 2017-12-06T05:53:01Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418686#M26957 No use of macro unless you want to merge different 15 datasets from time to time, AND you have some other logic than just the merge you want to reuse. Wed, 06 Dec 2017 07:14:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418686#M26957 LinusH 2017-12-06T07:14:07Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418861#M26966 <P>You will have to consider to you have any variables in the 15 sets other than the ID that have the same name?</P> <P>If they have the same name which value do you want to keep?</P> <P>If so are the all the same type? If there same named variables with different types you will likely get an error.</P> <P>If the like named variables are character what length do you want it to be. You can get truncation of data with different lengths.</P> <P>&nbsp;</P> <P>What have you tried so far?</P> Wed, 06 Dec 2017 16:35:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-MACRO/m-p/418861#M26966 ballardw 2017-12-06T16:35:54Z