04-18-2016 03:11 AM
Save the sheets each as .csv, then you can use infile/input.
.XLSX can only be used with proc import or libname.
04-18-2016 03:44 AM
Read my post. Save to a textual format that is compatible with text input, and you can use a data step with infile/input.