04-15-2013 06:39 AM
Looks like you are doing things a bit more complicated than needed.
Instead of passing a list of tables to the macro, just call the macro for each table. That will reduce the amount of logic within the macro, and therefore easier to maintain (and troubleshoot).
04-15-2013 09:04 AM
I'm familiar with this application, and can promise you that this is just a test run. There are actually more like 80 data sets to be processed.
You will have to attach the log if you want any help from the forum. That's what tells us what went wrong. If you didn't have the MPRINT option in place, you may need to re-run with it before posting the log:
04-15-2013 10:00 AM
2 or 80, does that matter?
The effort to write the call is about the same, just repeating the macro name...?
Even better, having all contributing tables in a lookup table, or reading the names from sashelp.vmember, you could use call execute.
04-15-2013 12:51 PM