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.
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.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.