Hello @Balasooriya The issue appears to be with the import part of your code. Try the following and let us know the outcome
FILENAME REFFILE 'D:\Acadamic\MS plant breeding\4th semestor\Dr Hettiarachchi\trial2.xlsx';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.try1 replace;
GETNAMES=YES;
RUN;
Once this is done, the rest of code should work.
... View more
