Hi, I'm trying to use SQL to inner join 2 SAS files, here is what I have: proc sql;
select Rank.NOC, Rank.Country, Gold_2018, Silver_2018, Bronze_2018
from ab.rank2018 inner join ab.rank2016
on rank2018.NOC=rank2016.NOC
on rank2018.Country=rank2016.Country;
quit; My question is that because Country and NOC occur in both tables, I have the use the table prefix to indicate which column to use, which I choose olympics2016, however it doesn't work, it still gives me two table. Can someone please help me to fix it? Thank you.
... View more