Hi SAS Experts, 1.I have a requirement to read an excel file in to SAS and generate a single SAS dataset 2.The said excel file has multiple worksheets. 3.The data is stored in a pre-determined cells whoose position is same in all worksheets example below worksheet1 - cell c10, d10,c20,d20, c30,d30 and so on. worksheet2 - cell c10, d10,c20,d20, c30,d30 and so on. and so on. 4. My SAS Dataset must only contain the c10,d10 ---- cxxx, dxxx values from all worksheets one below the other. 5. I only know how to read a range of values like range of rows and columns in excel but not specific cells. 6. How do I make it happen? Please convey your ideas? Thanks,
... View more