DATA Step, Macro, Functions and more

Is there any quick way to import multiple Excels into SAS and merge them into one dataset

Reply
Contributor ZZB
Contributor
Posts: 34

Is there any quick way to import multiple Excels into SAS and merge them into one dataset

I need to import about 120 Excel files into SAS and merge them into one dataset. Each excel contains data for one sepcific month. The format of each excel is same.

It takes much time to import each excel into sas and append them each time. Is there any quick method to deal with such problem?

Thanks

Super User
Posts: 3,100

Re: Is there any quick way to import multiple Excels into SAS and merge them into one dataset

The answer is in the More Like This beside your post:

https://communities.sas.com/message/208571

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