Hi David,
Thanks for your time.
Well,Let me give some more information on the tables.
Table1
ID
1
2
3
4
.
.
10
Table2
ID FirstName LastName
1
2
3
4
.
.
a Million rows.
Proc sql norpint;
create table way1 as
select t1.*,
t2.firstname,
t2.lastname
from table1 as t1 left join table2 as t2
on t1.id=t2.id; quit;
Proc sql norpint;
create table way2 as
select t1.*,
t2.firstname,
t2.lastname
from table1 as t1 inner join table2 as t2
on t1.id=t2.id; quit;
Here the Table2 is a Master Dataset which will have all the ids with additional detail information.
For every id in Table1, there will be a row in Table2 with the same Id.
So, now my question is which is the best way to go!
Aravind