@rxp1970  Thank you for the compliment.  The folks in this forum are actually really supportive and helpful. It's just not always that simple to figure out how and on what level to give an answer. Seems I've been lucky this time.  When you continue using the forum here you'll figure out how to ask to get quicker responses - and people will learn to know you so they better understand what and on what level you need answers.   As for reading data from Excel spreadsheets: If this is an XLSX and your data (with or without column header) starts in cell A1 without any fancy layout (so just data without empty or summary rows) then you can also use a simple libname with the XLSX engine. The Excel file needs then to be under a path accessible by the SAS server (so not where your client sits but where SAS executes).   Here how such code looks like for your Excel reading sheet IN. libname mydata xlsx "/serverpath/bank-additional-full-separated.xlsx"; data want; set mydata.in; run;   Using the XLSX engine requires SAS/Access to PC Files licensed. A lot of site have it and I believe it's also part of the UA edition.  ... View more