hi , libname engine will also helps you ...for importing .... but try this .....i have excel (Y3DTR.XLS) having two sheets named PURCHASE , SWITCHES %MACRO IMPR(IMP,OUT_DAT,EXL_SHT); PROC IMPORT DATAFILE="&IMP" DBMS=EXCEL OUT=&OUT_DAT REPLACE; /*for oupput dataset for each SHEET */ SHEET="&EXL_SHT"; /*for specifying sheets */ MIXED=YES; RUN; %MEND IMPR; %IMPR(C:\Users\galax_allu\Desktop\Y3DTR.XLS,PURCHASE, PUR); %IMPR(C:\Users\galax_allu\Desktop\Y3DTR.XLS,SWITCHES, SWT); Regards, Allu
... View more