Hello All, I am trying to merge two data sets Table1 has 3000 observation and Table2 has 6000 observation. I am trying to merge two data sets with three different variable those are common in both data sets. So after executing the code below i get the Merge1 table with 6000 observation as expected. however the Merge1 table is missing the observation for the variable i selected from the Table1 which is a.ACCNR, A.AN, a. RLTVM ect. I checked the format of all three variables that i am trying to join in both data set and the format are the same. Also when i replaced right join with left join in the code below, i am missing the observation from the Table2. Does anyone have an idea why the resulting table is missing the observations? Proc sql; create table Merge1 as select a.ACCNR, a.AN, a.RLTVM_BA,a.CYCLE_PK, a.site, a.conc, a.LNCONC, b.ACCNBR_IF, b.RLTVM_IF, b.ACTDATE, b.PKTM, b.CYCLE_IF, b.AN_IF from Table1 a right join Table2 b ON a.AN=b.AN_if and A.RLTVM_BA=B.RLTVM_IF and a.cycle_PK=b.cycle_IF order by AN; quit;
... View more