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
... View more
