Hi   I really need help asap with one of the queries related to sas data extract.   Background:I have one input text file that contains data related to transactions which is spread across multiple lines having no delimiters.   Basically in first column I want text starting with @ until end of line; in second column text starting with :50:H until :21: in third column text stating with :21: until:71A: This will repeat until all :21: are considered in expected outcome Sample data: @20111819 :20:BFSC :28:DABC :50H:/191919 Amazon Sydney Australia :21:AU111 :23E:ABC :24C:DEF :71A:April :21:AU222 :23E:ABC :24C:DEF :71A:April :21:AU333 :23E:ABC :24C:DEF :71A:April @20111820 :20:BFSC :28:DABC :50H:/191919 Amazon2 Sydney Australia :21:AU111 :23E:ABC :24C:DEF :71A:April :21:AU222 :23E:ABC :24C:DEF :71A:April :21:AU333 :23E:ABC :24C:DEF :71A:April   Expected Output: Column1 Column2 Column3 @20111819 :50H:/191919 Amazon Sydney Australia :21:AU111 :23E:ABC :24C:DEF :71A:April @20111819 :50H:/191919 Amazon Sydney Australia :21:AU222 :23E:ABC :24C:DEF :71A:April @20111819 :50H:/191919 Amazon Sydney Australia :21:AU333 :23E:ABC :24C:DEF :71A:April @20111820 :50H:/191919 Amazon2 Sydney Australia :21:AU111 :23E:ABC :24C:DEF :71A:April @20111820 :50H:/191919 Amazon2 Sydney Australia :21:AU222 :23E:ABC :24C:DEF :71A:April @20111820 :50H:/191919 Amazon2 Sydney Australia :21:AU333 :23E:ABC :24C:DEF :71A:April Can someone please help me with this. ... View more