The data is very long and just a single row. I just have 4 segments from the long line. CLM*178*322.56***12+B+1*Y*A*Y*Y**NTE*19*94289*WER~CLM*123 *322.56***11+A+1*Y*A*Y*Y* *90289*RRW~CLM*223 *322.56***11+A+1*Y*A*Y*Y* NTE*11*93289*RRW~CLM*120 *322.56***11+A+1*Y*A*Y*Y* NTE*17*91289*SEW~ I want CLM NTE 178 19 123 Blank 223 11 120 17 I have almost 15,000 CLM in the long line. Sometimes the NTE segment is itself missing and it messes up my output. Here is my code : data a_111; infile 'E:\Users\Documents and Settings\57260\Desktop\test\.W.160712102723.086.dat' lrecl = 1000000000 ; input @'CLM*' string $3. @'NTE*' COS $2. @@; run; how to account for when NTE segment is missing. I have attached a small sample of data I will appreciate your help in this regard.
... View more