Plain text isn't really a SAS killer app, unless you are into text mining. Your sample data is quite confusing. And what is your output? A database table or a report? Do you consider all lines of data as one block of information (variable in SAS), or is each line a separate item. If the later, you need some measure to match the profile line with its corresponding Work line...or...?
... View more
