hello i want to import multiple xls sheets to sas . please guide how to do it ?
I strongly advise you, if you have to use Excel at all, to move that data into a .xlsx file. .xls is the very old binary file format MS used to use back in 2000 and before. It shouldn't be used nowadays. Technology has moved on a lot since then, and assuming your SAS version is 9.3 or later you can simplify your process if you xlsx to:
libname tmp xlsx "c:/path/to/file/yourfile.xlsx"; proc copy in=tmp out=work; run; libname tmp clear;
You can see the engine in action:
https://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.