Try Using something like this : filename soy dde 'Excel|C:\Courses\Independent Study\Data\[SOYREF95.XLS]REF95!R2C2:R229C10'; data bean; infile soy missover; input labid $ month reps moisture abn dead abn1 abn2 abn3; run; proc print data=bean; run; Link : http://www.ats.ucla.edu/stat/sas/library/SASRead_os.htm#ReadingExcelFilesIntoSAS Thanks!
... View more