I have two Tables X and Y .
X contains goals for the current year
y contains Achievements for the current year.
X TABLE Y Table
Year Rocket sales Achievement date (if date is marked we have to count a one achivemement)
Months Bat Sale Achievement date (if date is marked we have to count a one achivemement) Rocket Goal
I find only location as primary key, but i think its maps up multiple location since day wise achivements are present.
Request help on how to map both the tables and get Goal Vs Ach
Pls suggest me with an answer for the below question.
If I understand your question correctly, you would like to add more than one join condition between these 2 tables. You can do this by creating a data query in the data builder (‘data preparation’ from the Home page).
Here’s some information about creating the data query using the data builder: http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n14yl8nwnuk797n1oqvbg...
From your data query, you can add join conditions from the ‘Joins’ tab. Click the plus sign (+) to add additional joins. Here’s some more information about working with joins:
Afterwards, you can use your data query to create reports and explorations.
Please let me know if this was the information that you were looking for.
Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.