topic Proc SQL Left Inner Join in SAS Programming

Proc SQL Left Inner Join

dtchoi86 — Fri, 06 Feb 2015 14:41:42 GMT

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!

Re: Proc SQL Left Inner Join

gergely_batho — Fri, 06 Feb 2015 14:48:25 GMT

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

Re: Proc SQL Left Inner Join

RW9 — Fri, 06 Feb 2015 14:51:37 GMT

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.

Re: Proc SQL Left Inner Join

dtchoi86 — Fri, 06 Feb 2015 16:22:01 GMT

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

Thank you again!