Hello, I need to create multiple datasets, each one the product of a merge of two tables. Then I need to print the output of this merge. I have to do this around 60 times so I am hoping I can use a macro to do this, but I am new to them and have not worked with them before. Here is my code that I will need to run over and over again and the bolded objects will change each time. data merge_one; merge tbl1 (in=a) tbl2 (in=b); by id; if not b; proc print data=merge_one; where id like '01%'; var id date staff; run; any help would be much appreciated.
... View more
