Hello, i work on Viya 4 with sas Studio and flow.
Before i work with SQL Query. It's very clear for me with SQL. You have ton possibilities :
LEFT JOIN Table2 on Table1.Var = Table2.var
where varX .... and VarX.....
Or LEFT JOIN Table2 on Table1.Var = Table2.var and varX= .... and VarX=.....
And the result of these 2 queries are not equal.
In SAS STUDIO, i'ts easy for me to to the second one. But, for the first on, i don't manage to do it. Perhaps, i can use the expression generator but i don't know how to write it.
Can you help me?