topic Re: How to maintain the row order after joining? in SAS Programming

How to maintain the row order after joining?

zhangda — Thu, 01 Sep 2016 20:35:55 GMT

Hello,

I am joining two tables, testA, testB.code is as below, but how can I maintain the order of column name value, as H C D, instead of C D H after joining? Thank you so much!

data testA;
input name $ number;
datalines;
H 4
C 7
D 9
;
run;

data testB;
input name $ class;
datalines;
H 88
C 99
D 0
;
run;

proc sql;
create table final as
select a.*,b.* from testA a left join testB b on a.name=b.name;
quit;

Re: How to maintain the row order after joining?

Reeza — Thu, 01 Sep 2016 20:38:01 GMT

You can't by default. If you have a variable you can sort by add that your order by statement.

If you don't have a sort var you'll have to create one.

Re: How to maintain the row order after joining?

ballardw — Thu, 01 Sep 2016 20:51:12 GMT

One way to implement @Reeza's suggestion:

data testA;
input name $ number;
order = _n_;
datalines;
H 4
C 7
D 9
;
run;

data testB;
input name $ class;
datalines;
H 88
C 99
D 0
;
run;

proc sql;
create table final as
select a.*,b.* from testA a left join testB b on a.name=b.name
order by order;
quit;