Posted By

sarathannapareddy on 08/11/09


Tagged

data merge macros sas step DO-LOOP


Versions (?)

Merging data sets using macro code/ Macro for merging datasets


 / Published in: SAS
 

URL: http://studysas.blogspot.com/2009/02/merging-data-sets-using-macro-code.html

Merging the data sets with a common variable if the datasets has the same prefix name?

For example: col1-col10 dsn1-dsn 7 data1 to data6 with common variable of Usubjid.

  1. here is the example, I have 7 datasets i need to merge and each of them having the common variable(usubjid) to merge, and all the datasets having the same prefix dsn(dsn1 to dsn7).
  2.  
  3. %macro allmerge (n);
  4. data combine;
  5. merge %do i = 1 % to &n;
  6. dsn&i;
  7. %end;
  8. by usubjid;
  9. run;
  10. %mend;
  11. %allmerge (7)
  12.  
  13. Sarath
  14.  
  15. www.studysas.blogspot.com

Report this snippet  

You need to login to post a comment.