I have this Code PROC SQL; CREATE TABLE WORK.SNAP_1 AS SELECT t1.text, t1.Date_C01, t1.Date_C02, t1.ContryA, t1.Area, t1.MONTH, t1.Revision, t1.COMGRP, t2.Group, t2.Top_Exports, t2.Top_Imports FROM WORK.SNAP t1 INNER JOIN WORK.COM_CODES t2 ON (t1.COMGRP = t2.COMGRP); QUIT; There are 128037 records in T1 (Snap) and because I just want to add additional records to this table I am doing an INNER JOIN However, the resulting table SNAP_1 has more records Any ideas why this is so? and how can I correct it?
... View more