hello i want to import multiple sheets to sas .

[Shrutibhatnagar]

hello i want to import multiple xls sheets to sas . please guide how to do it ?

[andreas_lds · Accepted solution]

Google will reveal how to do this. Using libname-statement and proc copy is one way. Writing a proc import for each sheet is another way. Best thing you could do: export all sheets to CSV and use a data-step to read each. This is imho the only.way to get a reliable importing-process.

[RW9]

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/