Does anybody know how I can join two tables via a full outer join when there are no common fields?
I have two tables, one table has a "valid period" defined by a "date from" field and a "date to" field, the other table has a field with
just one variable: "Statement Date".
I want to join the two tables using a "where" statement, the "Statement Date" must be between the "Date From" and the "Date To" value.
Because I don't have two common fields in the tables that I want to join, I get an error when I want to save the view without a join statement, but when I create the full join, I get an error because I don't actually name the fields to be joined.
I can do this in EG, but I thought it would be a good idea to create a view using the "Prepare Data" option in SAS V.A.
The idea was to create a view based on 2 tables that are already in memory in stead of creating an actual table.
I have found a very basic solution for this "challenge":
I have added a key field to both tables with the value 1.
I can now join both tables on this key field.
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.