Desktop productivity for business analysts and programmers

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

Reply
Contributor
Posts: 29

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

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;

Super User
Posts: 19,167

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

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

So googling will find you answers Smiley Happy

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

Ask a Question
Discussion stats
  • 1 reply
  • 313 views
  • 0 likes
  • 2 in conversation