How to Import multiple Excel sheet to one output table

[dwani]

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.

[Shmuel]

In order to help you please post:

1) few lines (the common column and few others, just for a demo and testing)

2) what output (merging or concatenating sheets) do you expect :

3) what was your code, what was your output and why it did not fit your expectations.