topic How to import multiple excel files residing in a SAS folder? in SAS Enterprise Guide

How to import multiple excel files residing in a SAS folder?

Rish — Wed, 06 Nov 2013 21:17:14 GMT

Currently I import daily excel files with different dates and then merge them into one big montlhy file. I read on the forum that I can use a macro to automate the process. I am not well versed with macro's, can somebody please shed some light? Thanks

File - 1

Proc IMPORT OUT= Test1

DATAFILE= "/sas/data_20131101.xls"

DBMS=xls REPLACE;

sheet = 7061_newdata;

GETNAMES=YES; MIXED=YES;

run;

File - 2

Proc IMPORT OUT= Test1

DATAFILE= "/sas/data_20131102.xls"

DBMS=xls REPLACE;

sheet = 7061_newdata;

GETNAMES=YES; MIXED=YES;

run;

Re: How to import multiple excel files residing in a SAS folder?

Reeza — Wed, 06 Nov 2013 22:34:47 GMT

There's some macros on the support.sas.com site.

So googling will find you answers

Here's an example for TXT files, perhaps you can modify it for Excel files. But I'm pretty sure there's one specifically for Excel on there.

24707 - Reading multiple files with PROC IMPORT