topic Re: PROC SQL Joins in SAS Programming

PROC SQL Joins

robertrao — Fri, 09 Sep 2016 17:06:24 GMT

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;

Re: PROC SQL Joins

Reeza — Fri, 09 Sep 2016 17:37:11 GMT

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.

Re: PROC SQL Joins

PGStats — Fri, 09 Sep 2016 17:54:40 GMT

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;

Re: PROC SQL Joins

ballardw — Fri, 09 Sep 2016 17:56:17 GMT

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