Join on a flow

YannRC — Sun, 31 Dec 2023 15:30:02 GMT

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?

Re: Join on a flow

Patrick — Mon, 01 Jan 2024 03:00:04 GMT

Using a current Viya 4 release I could generate the following code:

PROC SQL;
   CREATE TABLE WORK.'result'n AS
   SELECT 
      t1.'Name'n,
      t1.Sex,
      t1.Age,
      t1.Height,
      t1.Weight
   FROM
      SASHELP.class t1
         INNER JOIN SASHELP.class t2 ON (t1.'Name'n = t2.'Name'n)
   WHERE
      UPPER(t2.Sex) = 'F'
   ;
QUIT;
RUN;

Here the flow:

The where clause is based on the filter condition

topic Join on a flow in SAS Programming

Join on a flow

Re: Join on a flow