Importing Excel

[Rohan_Garg4]

What is the best way to import a .xls file with multiple sheets that you are interested in importing? Do you individually import each sheet or do a RANGE function?

[kirstinpruitt]

Hi - I am a fairly new SAS user myself, but it is my understanding that you would import each sheet and the RANGE function is utilized for subsetting data within a sheet. Maybe to avoid writing so much code, you could employ a macro to change the sheet names as many times as you desire. 

[Reeza]

LIBNAME + PROC COPY to read everything in quickly and at once.

I only use RANGE when I need to extract data that's in a weird format. This will copy all files from the Excel file to your work library in one shot. You can select specific sheets if you'd like.

libname myXL xlsx '/folders/myfolders/demo.xlsx';

proc copy in=myXL out=work;
run;

---

@Rohan_Garg4 wrote:

What is the best way to import a .xls file with multiple sheets that you are interested in importing? Do you individually import each sheet or do a RANGE function?

---