PROC SQL q

Reply
Frequent Contributor
Posts: 131

PROC SQL q

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!

Valued Guide
Posts: 854

Re: PROC SQL q

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

Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation