topic How to Join data into another table in New SAS User

How to Join data into another table

heyyou1 — Tue, 16 Nov 2021 21:28:43 GMT

I have two tables and I want to join them together.

The columns of table one are

name,
age,
birthday.

The columns of table two are

name,
salary.

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?

Re: How to Join data into another table

Reeza — Tue, 16 Nov 2021 21:37:35 GMT

Show the full log - where SAS indicates the error is informative.
No double == sign is one difference. I make the reverse mistake constantly in R 🙂

Re: How to Join data into another table

Reeza — Tue, 16 Nov 2021 21:54:40 GMT

Note that SAS also supports the Natural Join which is useful.

Re: How to Join data into another table

Tom — Tue, 16 Nov 2021 23:56:12 GMT

SAS will SHOW YOU where the mistake is.

70    proc sql;
71    CREATE TABLE all_data AS
72      SELECT a.*, b.* FROM
73      table1 a full join table2 b
74      on a.name == b.name
                   -
                   22
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.

75    ;
76    quit;

You have typed the equality operator symbol twice. Remove one of the equal signs, a.name=b.name, or just use the mnemonic equivalent, a.name eq b.name.

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrcon/p00iah2thp63bmn1lt20esag14lh.htm