How to maintain the row order after joining?

[zhangda]

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;

[Reeza]

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. 

[ballardw · Accepted solution]

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;