Note: I am using PC SAS 9.4 M2(x64). I have some Excel spreadsheets to import and each spreadsheet contains two datasets that ate stacked horizontally. Upstream Record_No, Col2, Col3, etc 1 , data, data, data 2 , data, data, data 3 , data, data, data n. , data, data, data Blank-row Downstream Record_No, col2, col3, col4 1 , data, data, data ...... ...... I'm thinking something like import the whole sheet into a dataset. Then a proc statement data = work.upstream. work.downstream. A do until loop until the blank row or merged cell 'downstream'. This data output to upstream and the remaining data to 'downstream' dataset. Any suggestions would be greatly appreciated ... View more