topic Re: hello i want to import multiple sheets to sas . in SAS Studio

hello i want to import multiple sheets to sas .

Shrutibhatnagar — Thu, 07 Mar 2019 05:46:14 GMT

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

Re: hello i want to import multiple sheets to sas .

andreas_lds — Thu, 07 Mar 2019 06:38:45 GMT

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.

Re: hello i want to import multiple sheets to sas .

RW9 — Thu, 07 Mar 2019 08:56:26 GMT

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/