Find same observations in two tables

[jcis7]

Hi,

I need to create a table that has the same building codes between both tables.

I want all variables from Table A

From Table B, I only want some variables;  Year, NumberUTD

Both tables may have matching building codes but we don't know.  That's what we would like to find out. 

[collinelliot · Accepted solution]

Something like this, though data would be helpful:

proc sql;
  CREATE TABLE want AS
  SELECT a.*, b.year, b.NumberUTD
  FROM tableA AS a
  INNER JOIN tableB AS b
  ON a.buildingCode = b.buildingCode;
quit;

I'm making assumptions about uniqueness of the data, variable names, etc., but something along those lines will give you what you want.