Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to Import multiple Excel sheet to one output table

Reply
Regular Learner
Posts: 1

How to Import multiple Excel sheet to one output table

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.

Super User
Posts: 1,256

Re: How to Import multiple Excel sheet to one output table

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.

Ask a Question
Discussion stats
  • 1 reply
  • 181 views
  • 0 likes
  • 2 in conversation