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

Data Preparation - Conditional Joins

Reply
New Contributor
Posts: 2

Data Preparation - Conditional Joins

Hi

 

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