https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669556#M200872 Convert your Excel files to CSV, read them in with the same data step, which allows you specify the variable types consistently. <BR /><BR />If they're all in the same folder something like this code will convert all in batch.<BR /><A href="https://gist.github.com/statgeek/878e585102c14e01581f55dbe972d27e" target="_blank">https://gist.github.com/statgeek/878e585102c14e01581f55dbe972d27e</A><BR /><BR /><BR /> Wed, 15 Jul 2020 16:07:16 GMT Reeza 2020-07-15T16:07:16Z https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669540#M200865 <P>I have 250 excel files of sec financial data that I am trying to stack into one master sheet of data. However, when I go to do this there is a discrepancy in variable types across the data. For example(hypothetical), column 3 will be the date filed and in some of the files it reads in as numeric and others it will read in as a character variable. This is causing issues whenever I goto stack the files. Any suggestions on what I should do?</P> Wed, 15 Jul 2020 15:54:10 GMT https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669540#M200865 dstevens32 2020-07-15T15:54:10Z https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669556#M200872 Convert your Excel files to CSV, read them in with the same data step, which allows you specify the variable types consistently. <BR /><BR />If they're all in the same folder something like this code will convert all in batch.<BR /><A href="https://gist.github.com/statgeek/878e585102c14e01581f55dbe972d27e" target="_blank">https://gist.github.com/statgeek/878e585102c14e01581f55dbe972d27e</A><BR /><BR /><BR /> Wed, 15 Jul 2020 16:07:16 GMT https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669556#M200872 Reeza 2020-07-15T16:07:16Z https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669839#M200995 <P>Concur with&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13879">@Reeza</a>&nbsp;'s suggestion. You will only be able to make this a stable process by eliminating the Excel file format as a transfer medium.</P> <P>Save to CSV and read with a data step.</P> Thu, 16 Jul 2020 09:02:47 GMT https://communities.sas.com/t5/SAS-Programming/Stacking-different-excels-of-same-data-into-one-sheet/m-p/669839#M200995 Kurt_Bremser 2020-07-16T09:02:47Z