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!
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.
If the other table is not so big (fits into memory), you can write a data step and use a hash object.
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.
I apologize for the last entry. I didn't know the code you posted was the answer.
Thank you again!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.