PROC SQL : oppesite of JOIN

[suicidedoor]

Hello,

in my University ive got this task:

ONE

red

green

brown

brown

TWO

purple

green

brown

my goal:

is get the colors who only shown once

with INNER RIGHT LEFT FULL JOIN

in this case

red

purple

i just wanna have a hint

wanna do the rest by my self 🙂

Thanks

[jakarman]

SQL INNER JOIN Keyword (just google to study/learning examples)  SAS is supporting Ansi SQL with some minor details being different.

[Patrick]

That's quite a good task as it will make you dive into the workings of SQL. One way to go: FULL JOIN with a HAVING clause - and eventually a COALESCE() in the SELECT

Another option here: SAS(R) 9.2 SQL Procedure User's Guide

[MichelleHomes]

The following  image may help you viisualize the various types of SQL joins...

[AndrewHowell]

Hi (suicidedoor?) - do you specifically have to use a JOIN clause. Your desired result could be achieved in SQL using SET operators.

[Scott_Mitchell]

You could perform a union all of one and two and then use a count function, group by and having clause to filter the results.