How to exchange and calculate data in a large number of excel documents through SAS?

[Guezien]

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

[PaigeMiller]

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.

[VDD]

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]

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?