https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56358#M12024 Posting the code you already have to import a single excel sheet will make it easier to suggest something useful. <BR /> <BR /> Combining proc import and basic macro code seem to be a good start. Thu, 29 Jul 2010 06:44:23 GMT andreas_lds 2010-07-29T06:44:23Z https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56356#M12022 Hi,<BR /> <BR /> I want to create a script which can load any excel sheet. For example: I have First excel in which I have 10 coloumns and second excel has 20 coloumns which are completey different from other. And so on.... <BR /> <BR /> <BR /> <BR /> Please let me know if there is any easy method to do through Program.<BR /> <BR /> Thanks for the help. Wed, 28 Jul 2010 07:08:14 GMT https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56356#M12022 SASACC 2010-07-28T07:08:14Z https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56357#M12023 try on of this method: excel engine, proc export, DDE Wed, 28 Jul 2010 15:14:50 GMT https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56357#M12023 deleted_user 2010-07-28T15:14:50Z https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56358#M12024 Posting the code you already have to import a single excel sheet will make it easier to suggest something useful. <BR /> <BR /> Combining proc import and basic macro code seem to be a good start. Thu, 29 Jul 2010 06:44:23 GMT https://communities.sas.com/t5/SAS-Programming/Loading-Excel-sheet-through-Program/m-p/56358#M12024 andreas_lds 2010-07-29T06:44:23Z