First, determine where the real data starts, column-wise.
Read all "columns" before that with sufficiently long character variables to not lose data. Drop those variables so that they do not clutter up the output.
In the data step, create two datasets. One to hold the table, the other to hold the "customer data".
Retain the variables needed for the "customer data", and assign values to them according to what you find, whenever you find it.
output the "table" dataset for every input line, but output the other only at the end.
... View more