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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.