SAS DI Studio Custom Transformation Help

[LinusH]

Well macro is the direction. But without writing the actual code for you...bu it will involve analysing how many input tables you have, and perform various %do loops for joining criteria.
But, building a macro for joining various no of input table is signalling to me at least that there perhaps is not much reusability here. Why not use the standard Join transformation?

[LinusH · Accepted solution]

I can't grasp the whole scenario in detail but is sounds like that each step could be preformed by other standard transformations.
Again, the join part is not a good fit for a user written transformation.