Hi,
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.
Best regards,
Theun
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.
If you have already prepared your data in EG, why not load that into VA?
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.