This is a very old thread.. But I wish to answer it incase anyone comes here looking for the answer: the coding will be proc import datafile = 'the path of the file' out = name of the dataset you wish to have dbms = xls or xlsx depending on the file extension range = 'sheet name $ and the range'; run; As per your data and file path the coding will be: proc import datafile="G:\Departments\Research\test scores\SCREADY\&prevyr.-&yr.\&yr.SCREADY.xlsx" out=state dbms=xlsx replace; range="&yr SC READY STATE$ A1:BS97"; run; Hope this helps ... View more