Proc SQL Left Inner Join

[dtchoi86]

Hello.

If there a way to do a left inner join, and the table produced from this procedure is not sorted.  It would be great to keep it in the order before the merge.

Thank you so much!

[gergely_batho]

If the other table is not so big (fits into memory), you can write a data step and use a hash object.

[RW9 · Accepted solution]

Assign and order variable before merging:

proc sql;

     create table WANT as

     select     A.*,

                    B.X

     from        (select *,MONOTONIC() as ORD from HAVE1) A

     left inner join HAVE2

     on           A.IDVAR1=B.IDVAR2

     order by  ORD;

quit;

Just to add though, if you want proper ordering setup variables for order before merging as "the order it was before merging" isn't a logical/replicate able statement.

[dtchoi86]

I apologize for the last entry.  I didn't know the code you posted was the answer.

Thank you again!