https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541833#M149680 <P>I wonder what sort of data you have in 6000 excel documents, and it's not clear what you want to do.</P> <P><BR />Are your excel sheets all with a common set of columns, so they can be read with the same code?<BR />Do you want a single big SAS data set as output, or do you want individual SAS data sets per sheet? <BR />Do you have one or more sheets per excel file? <BR />Is this a one-shot or something that should end as production code?</P> Sun, 10 Mar 2019 16:24:04 GMT ErikLund_Jensen 2019-03-10T16:24:04Z https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541808#M149669 <P>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</P> Sun, 10 Mar 2019 11:15:52 GMT https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541808#M149669 Guezien 2019-03-10T11:15:52Z https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541810#M149670 <BLOCKQUOTE> <P>How to make SAS able to establish the connection of these 6000 documents.</P> </BLOCKQUOTE> <P>&nbsp;</P> <P>One-by-one.</P> <P>&nbsp;</P> <P>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.</P> Sun, 10 Mar 2019 11:31:52 GMT https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541810#M149670 PaigeMiller 2019-03-10T11:31:52Z https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541824#M149676 <P>There is no way we can give you an answer to such a question. &nbsp;</P> <P>You have to think logically.&nbsp; 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.&nbsp; Hope they have names that somewhat make since.</P> <P>&nbsp;</P> Sun, 10 Mar 2019 14:36:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541824#M149676 VDD 2019-03-10T14:36:56Z https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541833#M149680 <P>I wonder what sort of data you have in 6000 excel documents, and it's not clear what you want to do.</P> <P><BR />Are your excel sheets all with a common set of columns, so they can be read with the same code?<BR />Do you want a single big SAS data set as output, or do you want individual SAS data sets per sheet? <BR />Do you have one or more sheets per excel file? <BR />Is this a one-shot or something that should end as production code?</P> Sun, 10 Mar 2019 16:24:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-exchange-and-calculate-data-in-a-large-number-of-excel/m-p/541833#M149680 ErikLund_Jensen 2019-03-10T16:24:04Z