Scenario:
I build a macro; input to macro will be a dataset.
Problem:
dataset being passed to macro can have any number of columns & records.
it will be different everytime macro runs.
Macro is expecting me to bind the data; what if i have 15 columns and in next run only 5 columns.
How to hadle this ?
The macro input at least needs a "sample" data set to use as a starter to run the processes down the line. The amount of columns and rows shouldn't be an issue as long as the columns you'll be using further down the line of your macro are always present in the data you are pointing to to start your macro.
I hope this helps!!