11-04-2016 03:25 AM
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.
11-04-2016 10:13 AM
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.