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
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.
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.
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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.