I'm trying to inner join two tables imported from Excel both tables have the same SIN data set and I keep getting ERROR: Column SIN could not be found in the table/view identified with the correlation name ST. ERROR: Column SIN could not be found in the table/view identified with the correlation name ST. ERROR: Column SIN could not be found in the table/view identified with the correlation name CT. ERROR: Column SIN could not be found in the table/view identified with the correlation name CT. ERROR: Column Credits could not be found in the table/view identified with the correlation name CT. both excel tables have a SIN data set CODE: proc sql; select st.*, ct.Credits from work.'students table'n as st inner join work.'course table'n as ct on st.SIN = ct.SIN ; quit;
... View more