Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Data Preparation - Conditional Joins

New Contributor
Posts: 2

Data Preparation - Conditional Joins



I have run into difficulty when trying to build a data query using the data preparation tool.  I'm wondering if this is a restriction of the data prep tool and if I need something like DI Studio?


I would like to do a conditional JOIN, specifically using an ISNULL statement to JOIN and a certain ID - if another ID happens to be NULL


Can anyone help?

Super User
Posts: 5,914

Re: Data Preparation - Conditional Joins

Posted in reply to Adam_Buckley

Can you elaborate, perhaps write a skeleton SQL, and small set of sample data?

Perhaps an outer join will work for you...

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation