https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Import-multiple-Excel-sheet-to-one-output-table/m-p/309281#M5755 <P>In order to help you please post:</P> <P>1) few lines (the common column and few others, just for a demo and testing)</P> <P>2) what output (merging or concatenating sheets) do you expect :</P> <P>3) what was your code, what was your output and why it did not fit your expectations.</P> Fri, 04 Nov 2016 14:13:05 GMT Shmuel 2016-11-04T14:13:05Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Import-multiple-Excel-sheet-to-one-output-table/m-p/309197#M5751 <P>I need to Import around 4 excel sheet and create report by merging of this 4 different table. In this 4 table I have different column sets , only 1 column name is common but data of this column is different accross all 4 table. I tried to go with data prepration and create query to join table, but its not giving me required output.I am working on SAS 7.3.</P> Fri, 04 Nov 2016 07:25:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Import-multiple-Excel-sheet-to-one-output-table/m-p/309197#M5751 dwani 2016-11-04T07:25:03Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Import-multiple-Excel-sheet-to-one-output-table/m-p/309281#M5755 <P>In order to help you please post:</P> <P>1) few lines (the common column and few others, just for a demo and testing)</P> <P>2) what output (merging or concatenating sheets) do you expect :</P> <P>3) what was your code, what was your output and why it did not fit your expectations.</P> Fri, 04 Nov 2016 14:13:05 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Import-multiple-Excel-sheet-to-one-output-table/m-p/309281#M5755 Shmuel 2016-11-04T14:13:05Z