topic PROC SQL q in SAS Programming

PROC SQL q

Maisha_Huq — Wed, 20 May 2015 16:30:43 GMT

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!

Re: PROC SQL q

Steelers_In_DC — Wed, 20 May 2015 16:37:23 GMT

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