PROC SQL q

[Maisha_Huq]

Hello:

When I create table using proc sql and the variable I am joining the tables "by" is in a different order of observations for each of the different tables being joined, what should I do to ensure proc sql creates the table where observations are matched?

Thank you!

[Steelers_In_DC]

There's a lot of documentation out there on this topic:

proc sql;

  title 'Inner Join';

  select *

  from lefttab as l inner join

  righttab as r

  on l.continent=r.continent;

Base SAS(R) 9.2 Procedures Guide