Hi @Patrick Thank you for your feedback. It is something that I wanted to test if it is feasible. And, I completely agree that Data step is much more robust than a Proc Import. Proc Import assigns the attribute length based on first few observations in the source file, so there is high risk of information truncation if the length increases in the subsequent records. Also, there are other benefits that you highlighted. Talking about your suggested options, I'm more aligned to go for Option 1. I have attached a document to describe what I'm trying to achieve. I'm looking for a SAS code that can separate my actual information from the trailer record into 2 separate files and then I could use the DI transformations like file reader to read them separately. One important point, my source file can have 1 million+ records, so it be good to to split the records in a single step to avoid reading a large source file twice. @Tom @Patrick : Can you help me write this code?
... View more