I have two tables and I want to join them together.
The columns of table one are
The columns of table two are
How do i merge the data from table 2 into table 1 where the names are the same?
proc sql;
CREATE TABLE all_data AS
SELECT a.*, b.* FROM
table1 a full join table2 b
on a.name == b.name
;
quit;
However, I get this error.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.
How do I do this?