09-09-2016 01:03 PM - edited 09-09-2016 01:06 PM
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
create table want as
from have as hv
left join table1 as tab1(where=var1 ne .)) on tab1.ID=hv.ID
09-09-2016 01:37 PM
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.
09-09-2016 01:54 PM
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;
Need further help from the community? Please ask a new question.