BookmarkSubscribeRSS Feed
Guezien
Calcite | Level 5

For example, I want to use the data in 30*200 excel documents for calculation. How to make SAS able to establish the connection of these 6000 documents

3 REPLIES 3
PaigeMiller
Diamond | Level 26

How to make SAS able to establish the connection of these 6000 documents.

 

One-by-one.

 

Elsewhere in this forum, the problem of reading lots of Excel files has been discussed many times, and code provided to read in many Excel files via a loop.

--
Paige Miller
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

There is no way we can give you an answer to such a question.  

You have to think logically.  if there are 6000 (Excel, sheets, workbooks, csv-view) or if there are 6000 payment entries you have to process them one at a time.  Hope they have names that somewhat make since.

 

ErikLund_Jensen
Rhodochrosite | Level 12

I wonder what sort of data you have in 6000 excel documents, and it's not clear what you want to do.


Are your excel sheets all with a common set of columns, so they can be read with the same code?
Do you want a single big SAS data set as output, or do you want individual SAS data sets per sheet?
Do you have one or more sheets per excel file?
Is this a one-shot or something that should end as production code?

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
  • 3 replies
  • 893 views
  • 2 likes
  • 4 in conversation