PROC SQL Joins

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

PROC SQL Joins

[ Edited ]

Hello Team,,

 

I have several left joins as shown and while joining i want to write a condition so unwanted records are not coming up in the final output.

I cant at the same time remove thoswe after the joins are made because then it might remove some of the records we want to keep

 

 

Proc sql;

create table want as

select *

from have as hv

left join table1 as tab1(where=var1 ne .))  on tab1.ID=hv.ID

left join...

left join....

where

quit;

run;


Accepted Solutions
Solution
‎09-09-2016 02:21 PM
Grand Advisor
Posts: 10,210

Re: PROC SQL Joins

Besides mismatched )

This part

left join table1 as tab1(where=var1 ne .))  

maybe should be

left join (select * from table1 where=var1 ne . ) as tab1   

View solution in original post


All Replies
Grand Advisor
Posts: 17,338

Re: PROC SQL Joins

Ok. You haven't provided enough details to understand what you're having issues with or what you need help with.

Please post sample input/output data as well as details of how you want your filter to work and why WHERE clauses or ON isn't working.

Respected Advisor
Posts: 4,606

Re: PROC SQL Joins

Is it just a syntax problem

 

Proc sql;
create table want as
select *
from 
	have as hv left join 
	table1(where=(var1 ne .)) as tab1 on tab1.ID=hv.ID left join...
where ...;
quit;

  

PG
Solution
‎09-09-2016 02:21 PM
Grand Advisor
Posts: 10,210

Re: PROC SQL Joins

Besides mismatched )

This part

left join table1 as tab1(where=var1 ne .))  

maybe should be

left join (select * from table1 where=var1 ne . ) as tab1   

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 315 views
  • 2 likes
  • 4 in conversation