Hi Mitchy, As has mentioned there are many approaches you can take in this situation. A simple method is using EXCEL Ranges and PROC COPY.  I am using PCFILE SERVER to access the EXCEL Workbook.  If you aren't using the PC FILE SERVER, you just need to change the LIBNAME statement to use your preferred method.  I would suggest that you maintain the acceptable SAS naming conventions when importing the data for named ranges, however if you are unable to do so you will need to use SAS name literals, which means enclosing your name in single quotes  followed by an N  e.g. 'SUM TOTAL'N.  I have other methods to correct for names that do not meet the SAS naming conventions, however they are more complicated and perhaps irreverent in your scenario. The following link shows how to create a dynamic in EXCEL range to ensure that you are capturing all your data when additional rows are added. How to create a dynamic defined range in an Excel worksheet LIBNAME XLSFILE PCFILES TYPE=EXCEL PORT=8621 SERVER=LOCALHOST PATH = "E:\NEWMICROSOFTEXCELWORKSHEET.XLSX"; PROC COPY INLIB=XLSFILE OUTLIB=WORK; /*THE LIBRARIES WHERE THE DATA ARE PRESENTLY LOCATED - INLIB AND THE OUTPUT LIBRARY - OUTLIB */   SELECT SAMPLERANGE TESTRANGE VARRANGE;/*THE NAMES OF  THE RANGES YOU WISH TO IMPORT - NAMES ARE RETAINED IN THE OUTLIB*/ RUN; LIBNAME XLSFILE CLEAR; There are more dynamic ways of importing all ranges, however given you will have to set up the ranges in EXCEL initially anyway, it is probably overkill in this situation. Regards, Scott ... View more