BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Armand
Calcite | Level 5

I have multiple workbooks (xls) with different name i am trying to import into SAS PC. i am using proc import multiple time to do the job.

Workbooks name are : Soccer, Tennis and Golf saved in: H:\user\document\sas

I created a library name Mywork

Help to use a macro?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

%macro import_xls(input, output);

proc import datafile="H:\user\document\sas\&input..xls" out=mywork.&output DBMS=xls; run;

%mend;

%import_xls(soccer, soccer);

%import_xls(golf, golf);

View solution in original post

6 REPLIES 6
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

Well, probably the quickest way is to do a libname to the Excel file.  You can then access the various sheets as datasets.  Here is some guidance: http://www2.sas.com/proceedings/sugi31/024-31.pdf

Armand
Calcite | Level 5

the pdf suggested has good stuff but that s how i did. I thought there is macro way to do that when you have multiple excel files to import from external.


art297
Opal | Level 21

It would help if you showed the proc import code you used to successfully import the three workbooks.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Yes, post your code.  What do you mean by "thought there was a macro way to do it"?  You can put most code you like in a macro, but there is nothing special about macros, to all intents and purposes it is just a find and replace system to save you typing the same code over and over.  If you know the sheetnames, then you could put your import into a macro with sheetname="&macro variable." and call it once per sheet.  Is there much value though?

Reeza
Super User

%macro import_xls(input, output);

proc import datafile="H:\user\document\sas\&input..xls" out=mywork.&output DBMS=xls; run;

%mend;

%import_xls(soccer, soccer);

%import_xls(golf, golf);

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 2273 views
  • 0 likes
  • 4 in conversation