BookmarkSubscribeRSS Feed
dwani
Calcite | Level 5

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.

1 REPLY 1
Shmuel
Garnet | Level 18

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 684 views
  • 0 likes
  • 2 in conversation