topic Re: Importing Excel in SAS Programming

Importing Excel

Rohan_Garg4 — Tue, 15 Dec 2020 23:01:57 GMT

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?

Re: Importing Excel

kirstinpruitt — Wed, 16 Dec 2020 00:12:26 GMT

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.

Re: Importing Excel

Reeza — Wed, 16 Dec 2020 00:35:58 GMT

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?