topic Find same observations in two tables in SAS Procedures

Find same observations in two tables

jcis7 — Fri, 03 Mar 2017 22:57:46 GMT

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.

Re: Find same observations in two tables

collinelliot — Fri, 03 Mar 2017 23:09:45 GMT

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.