BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ThdB
Obsidian | Level 7

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
ThdB
Obsidian | Level 7

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.

 

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star

If you have already prepared your data in EG, why not load that into VA?

ThdB
Obsidian | Level 7

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.png

 

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. 

 

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
  • 2 replies
  • 890 views
  • 0 likes
  • 2 in conversation